Global functions in access?

[dreamspy]

My question in short:

Can I make a global function in access? (some function that I can call from every form in the database),


My problem:

I have an access database. It has a startup menu for the user, which has some buttons on it. Each of these buttons take you to another menu with more buttons. These buttons then take you to different forms and queries in the database. A simplyfied structure of menu's looks something like this:

Now when someone opens up Menu1 and then Menu 1.1, and then goes to menu 2 f.x., the user has 3 open menu's. What I would like to do is to call a global function that closes all menues (except the startup menu), everytime a menu is opened (everytime a button is pressed). I know how to write the code to close the menu's (forms), but I don't know how to make a global function in access. Any hints?

regards
Frímann

 

[RuralGuy]

Simply create a new Module and put your Function or SubRoutine in it, but don't name it anything like the names of your Functions or SubRoutines.

 

[dreamspy]

easy as 1, 2, 3 thanks!