The way to solve the context problem is to make a custom menu bar for your
reports.
Simply specify the menu bar in the reports property sheet, and it will
appear when a report is launched.
The code that you can use for the print command that will show the print
dialog is:
DoCmd.RunCommand acCmdPrint
If you have a form with a timer event, you can experience a focus problem,
so I actually have my menu option call the following code:
Function DisplayPrintDialog()
On Error Resume Next
DoCmd.SelectObject acReport, Screen.ActiveReport.Name
DoCmd.RunCommand acCmdPrint
End Function
--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
(E-Mail Removed)
http://www.attcanada.net/~kallal.msn