Multi-user: Lock a form

[mlopes1]

I have a multi-user database which is used by 2 people over our network. Occasionally, the 2 users will access the same form(there are dozens). Because most of the forms OnOpen event clears the underlying table, I don't want a second user to be able to open it.

I tried record locking, but that does not work because each of the forms exports to Excel, which says the record source is locked and can't be accessed.

I also tried using the code I found on a previous post with the function IsFormOpen... but this does not work with the multiple user setup I have.

Am I missing something obvious here? If user1 on computer 1 has form1 open, then user2 on computer2 should not be able to open form1 at all...

Any ideas?

thanks,

Marco

 

[Mile-O]

Your best bet it to write to a table that someone has the form open and on the calling form you can check if there is someone in that form and give a message if they will not, temporarily be ables to access it.