Hi all,
Am having problems locking forms with multiple users, currently Access only notifies you another user has the form open when you go to save it.
What I would like is a macro so that when a user exists the form they are on the macro takes them to the next available form that is not open. (there is other criteria I require but have been able to overcome those problems)
I am finding this problem totally frustrating so if any one can help it would be greatly appreciated.
Thankyou in advance
Cameron
P.S. I do not know VB
Am having problems locking forms with multiple users, currently Access only notifies you another user has the form open when you go to save it.
What I would like is a macro so that when a user exists the form they are on the macro takes them to the next available form that is not open. (there is other criteria I require but have been able to overcome those problems)
I am finding this problem totally frustrating so if any one can help it would be greatly appreciated.
Thankyou in advance
Cameron
P.S. I do not know VB
