Printer Prompt

[funderburgh]

Is there a way to enable a "printer prompt" dialog box out of a report? When I print directly from Access I am given a prompt box, where I could select a printer, but in my reports the print executes without a prompt. I am using DoCmd OpenReport from VBA for printing.

 

[ByteMyzer]

The following VBA command sequence should do what you want:

DoCmd.SelectObject acReport, "[b][i]MyReport[/i][/b]"
DoCmd.RunCommand acCmdPrint

 

[funderburgh]

Very cool, thank you for sharing your wisdom.