Menus

[Sameal]

I have built a custom global menu for one of my database applications. I then set a sub-routine call for each of the menu item's ACTION properties with this syntax:

=MN_View_Sales()

My question is this, where does the actual sub-routine code go? The help files allude to creating a global module to hold these but when I place my sub-routines inside my 'modGlobal' I get an error stating that the sub-routine is an unrecognized call. I then tried to change the ACTION property to:

=modLogin.MV_View_Sales()

But this didn't work either. So I thought maybe I had to use the name qualification like with the form objects so I tried:

=[Modules]!modLogin.MV_View_Sales()

But again this gave me an error. I'm so confused where can I put my code? And is [Modules]! the correct way to fully qualify the name of a module in Access?

 

[Sameal]

Excuse me, all calls were 'MN_View_Sales' not MV...this is not my problem. =)

 

[Sameal]

Okay this is turning out to be a serious problem. I found that I could place the function statements into the startup form. Everything was working as long as the startup form was visible and active. But once focus moved to main switchboard, and the startup form was set !visible and sent to background, the menus cease to work.

Under menu help it says that you can use custom functions to run menu items but it never says where these functions must be set. I have no clue and am running out of time for this project. Any help would be appreciated.

 

[Sameal]

bump