I have a custom menu bar that loads when certain forms are open. Right now all the menu options that I have run existing menu commands from Access. This is good, however I would like to be able to run a section of code (stored in a module) from a custom menu command. Can this be done? I can do it by setting a menu command to open a form and then call the module code from the form's OnOpen event, however that would require a different form for every piece of module code that I want to run. Any other suggestions?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Run module code from a custom menu command?
- Thread starter utc13
- Start date
WhiteZiggy
Programmer
U can set Macros to run the section of module code and call the macros from the menu bar. Just place the "Run Macro" button on the menu bar then edit the properties to run the specific macro/module....
Jeremy
Jeremy
- Status
Similar threads
- Locked
- Question