Record Locking

J

Jeff

Hello,

For a multiuser database, I have a Form with a Subform in it
& when user DoubleClicks on that record it opens up another
Form that is Bound to a Table & displays
the data for that record that the user Double clicked on.

But before the Form Opens displaying the data for that record, I want to
check if that record is already open by another user & if so then display a
Messgae that it is open & then NOT allow it top be opened. How can this be
done ?

I have played around with setting "Record Locks" property to "Edited
Record", but that still allows Form to be open & then user cant change
anything. I want to capture or trap before so i can display a msgbox &
cancel opening.

I also tried setting "Record Locks" property to "No Locks" but then again
allows to open & then when user goes to save it displays default Access
msgbox. This does not work for me because then user would lose all info
typed in.

So basically some way to Trap if another record is opened before going in.
Any Acces funtion for this ? like IsOpened ?

Any help would be greatly appreciated,

Thank you,
Jeff
 
Top