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

[Salvatore]

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.