Once you have finished adding the commands to the menu, right click on each item, in properties, type in the text that you want to appear in the popup menu. It’s Caption will say “Sh.” or the start of whatever you decided to call the Menu. Drag your Macros which should appear under heading Commands (will be prefixed with Macro Name)to the very small Window that should have appeared. Select the Toolbars Tab from the Customize Window.ĭ. Right Click on any Menu Bar or select Tools > Customize from the Menu.ī. Create your print procedures using a Macro. To write a program from scratch, first create the universe. (Normally, clicking outside the menu would make it disappear, but you can't make that work with a form.) Include a Cancel button to let the user close this form without selecting any report. When the user clicks one of the menu buttons, open the report and close the popup form. When the user clicks the Print button, you just open the form.
Use command buttons with the Flat special effect to print the reports. Set the form's Modal and Popup properties to Yes, and its Border Style to None. What I would recommend is that you simulate a popup menu using an actual form. For instance, the user could close the form or click on another form, and the menu would be left displayed inappropriately. You could use an Office Toolbar-type CommandBar instead, but that has a little problem: it wouldn't be displayed modally, so the user could click the Print button to show the "menu", and then do something besides clicking a button on the menu. Access won't display a shortcut menu in response to DoCmd.ShowToolbar. If by "popup menu" you mean a shortcut menu, I don't believe you can do this.