MS Access forms

[Kan09]

I have an MS Access database. The main switchboard has 3 forms witch the users access according to their needs.
The thing that i need to do now is prevent a user from entering a 2nd form or a 3rd form when he already has one opened. Basically i want the end user to be able to use only one form at a time.

Any ideas on how to do that??

Txs

[JJ Instr]

I presume you have a command button that exit form or return to main menu or something. The coding for this button is automatically done if you use the "Wizard" for the button. In my example I use a "Return to Main Menu" Button. Below the following code "On Error Go To Err_Return_To_M ain_Menu_Click" Insert the code "DoCmd.Clos e" This close current form when you open "Main Menu" form. Do the same for all your forms.
Regards