check if form is being used by another user

[Guest]

Multi-user. BE on server. FE copies on workstations.

How can I check to see if another user is already using form "A"

If not, then I need to run a query to update the form's table; otherwise, I
don't need to run the query again, I just need to open the form.

Thank you!

 

[Rick Brandt]

Multi-user. BE on server. FE copies on workstations.

How can I check to see if another user is already using form "A"

If not, then I need to run a query to update the form's table;
otherwise, I don't need to run the query again, I just need to open
the form.

You are mistaken. Opening the form will automatically refresh the
underlying data. The only thing you won't see are changes the other user
makes AFTER you have the form opened. Anything that they have saved will be
there when you open the form without any actions taken on your part.

 

[Larry Daugherty]

No way you can tell.

HTH

 

[Guest]

Thank you!
The query is not the query for this form.
I need to see if other users are viewing this form.
Thank you any way. I appriciate your response!