**RESOLVED**Alerting Multiple Users in Access??

I have an Access 97 database set up with a form that multiple users will be accessing.

I currently set up the form to not allow multiple edits at the same time by setting the Record Locks to Editied Record..

This works fine for not allowing the users to overwrite each other's data while they are on the same record...

Also once the user opens the form it calls a parameter that asks a few questions so as to locate if a record is in the underlying table...if it is found then the user can add more to this record.

I am trying to figure out how to alert the 2nd or 3rd users that " User 1 is currently editing this record, please come back another time!"

Anyone have a suggestion as to how I could accomplish this?

Thank you.

Try opening the a record on PC1.
Then try to open same record on PC2.

You should get an error message. Note the error number.

in the Form_Open sub add

On error goto SorryAboutThat

...your code...

goto skipthis
SorryAboutThat:
if err.number = NUMBER_YOU_NOTED then
msgbox "Sorry come back later"
else
msgbox "Error: " Err.Number & " - " & err.message & "!"
end if
skipthis: