Link to home
Create AccountLog in
Avatar of SteveL13
SteveL13Flag for United States of America

asked on

Command button on a report possible?

Is it possible to put a command button on a report to close the report when clicked?
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
I use custom shortcut menus for all of my reports.

Take a look at mod_Menus in the attached.

In the Report Open event, I call MenuReport, which builds the shortcut menu, and then assign the ShortcutMenuBar to "MyReportMenu"

This menu has options for Print, Save as PDF, Send as PDF, and Close.  The ones I use usually have other options as well, Export to Excel, and several others, but those all involve a little more code and I don't have the time to pull those into this sample db at the moment
ReportMenu.accdb