printer dialog box

[pistolpinoy]

i'm wondering if i can display the printer dialog box by clicking a button in a form (form is active) and print a report without opening the same report.

thanks.

 

[rube]

This will select the report and bring up the Print Dialog Box. The only thing I don't like is it will bring up the database window, unless it is a run-time version.


DoCmd.SelectObject acReport, stDocName, True
DoCmd.RunCommand acCmdPrint