"EManning" <manning_news@[EMAIL PROTECTED]
> wrote
> Using A2003. I've got an FE with a main form with a subform. The
> subform is a mixture of bound and unbound fields. The main form is
> unbound and all it has on it is a combobox to choose a patient's
> name. Once the patient is chosen, the subform refreshes to show that
> patient's data. The problem I'm having is that 2 or more users could
> select the same patient and attempt to update the subform.
In multiuser environments, each user should have his/her own copy of the
Front End, linked to shared tables with data, in the Back End. That will
alleviate your problem... provided you use proper locking, which is
certainly possible...
Larry Linson
Microsoft Office Access
If user #2
> tries to update a bound field (haven't tried unbound yet) on the
> subform, they get a "beep" and the "no edit" icon appears in the
> record selector on the left-side. I'm trying to trap that to display
> a message to them that the patient is being edited by someone else.
> But I cannot seem to figure out where the error is occurring. I've
> set breakpoints in the Form_Error event, but it won't trap the error.
> I've set breakpoints in events for various bound fields on the subform
> but I still cannot trap the error. I would like for other users to be
> able to view the patient's data while another user is editing, just
> not be able to edit it.
>
> The BE mdb is set to Shared, and "Edited Record".
>
> Thanks for any help or advice.
|
