I am a beginner using access 2010
Have "Main Menu" form with buttons to open other forms. In every button there are two steps.1- Close this window (Main Menu)
2- Open the desired form
In all forms (except "Main Menu"), in the event close, I have the macro that opens the form "Main Menu" to have a form to go back and complete the navigation.
These are the steps to put you in context:
- In the "Main Menu" form, click the button "Assets List" that opens the form "Assets List" in a datasheet style.
- The first column of this datasheet is a Hyperlink that opens the the form "Asset Details", using the selected ID but does not close the "Asset List".
- With the "Asset Details" open, I can edit all the fields of the selected asset.
- When close the "Asset Details" form, I requery the "Assets List" form, but because I have in the "on close" event of all the forms the macro to open "Main Menu", now I have "Main Menu" and "Assets List" open.
What I want is: Before Load "Main Menu" ask if there is any form open. If yes, do not open "Main Menu". If there is no other form open, open "Main Menu".
I guess that I should write a the code in the "on open" event in the "Main Menu" form, but I do not know what to write. Could you please help me?
If there is a different way, I am open to new suggestions.
Thanks,
Danilo