Shortcut menus definition

[Cris VS]

Hello all,

I have a database with five forms, named A to E. I want to display custom shortcut menu 1 in forms A, B and C and shortcut menu 2 in forms D and E.

I was wondering where should I define the menus, in the "On load" event of each form or somewhere else?

Cheers

PS: I am asking this because previously I had defined menu 1 in "On load" event of Form A and then selected it as MenuBar for forms B and C, but when I modified the VBA code of form B the menu got deleted from A too.

 

[theDBguy]

Hi. If you simply selected the appropriate shortcut you want to assign in the menubar property of the form, instead of using the Load event, then the shortcut shouldn't go away even if you modify the VBA, because you wouldn't be using VBA to load it.

 

[Cris VS]

shouldn't go away even if you modify the VBA, because you wouldn't be using VBA to load it

So let's say I define the menu in Load event of form A and then select it from the menubar in Form B, if I have to add other events to form A's VBA, it will not affect form B? Cheers

 

[arnelgp]

you can Create a macro for your shortcut.
then assign this macro to the Shortcut Menu Bar of your form
on design view (property->other->shortcut menu bar).