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. 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.
