I have an application, with a custom menu, written in Access 2000. I'm using
the application in Access 2007, and I'm converting the custom menu to a
switchboard system (since Access 2007 doesn't support the design mode for
modifying the menu).
I have a switchboard command to print one of 23 reports, and ideally, that
command would open a second switchboard showing all of the reports, from
which I would select one of them, but I am limited to 8 by the switchboard.
I have designed a macro system which provides a custom pop-up menu which
will allow the selection of one of the reports, in accordance with the
Microsoft article "Create custom menus and shortcut menus by using macros". I
have tried to run this macro from the switchboard, either using the
switchboard "Run Macro" command, or using the Docmd method in VBA code, but
neither methoc will cause the macro to run and create the menu.
Please tell me how I can run this macro menu system from the switchboard.