multiple users issue

[AnnPhil]

Is there anyway when multiple users are sharing a form or printing a report that Access can make the user aware if someone is editing the record that they are LOOKING at? I understand record locking is to prevent more than one user from editing the same record, but what i am looking for is if a user is looking at a record that has a field such as "current balance" they would know if that field is being editing at the time they are looking at it. Hope that makes sense, right now the db is a single file because when it was orginially created it was for a single user. Is it possible to leave it as a single file and still be able to do this?

Thanks for any help.

 

[caman]

help?

I have a similiar problem to yours that I am trying to solve.
Currently Access only warns you on exiting.
So far what I have done is used the OnCurrent function in the form to Set Value =1 in a field called form open.
If your next user tries to open the record, as long as they have the Criterea on that field set to Is Null, they should skip this record and go to the next.
All I have to do now is work out how get the requery working and Ill be happy.

Dont know if that helps you, but I think its roughly along the lines of what youre looking for

Have a nice day

Caman