CustomSubMenus

[AccessAmateur]

How do I set up a custom submenu to run a code procedure instead of a Macro?
I have a form which was constructed using macros & queries & I am tried to thin out the multitude of macros.
Thanks

 

[Schof]

I believe you can only call a function and it has to be defined in a standard module (I.e. not a form module). Then in the Onaction field of your submenu call it like this:

=myFunction()

I you try to do this in VB make sure you put the equal sign in the assignment.

E.g. myCmdBarCtl.OnACtion = "=myFunction()"