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.

The following VBA command sequence should do what you want:

DoCmd.SelectObject acReport, "MyReport"
DoCmd.RunCommand acCmdPrint

Very cool, thank you for sharing your wisdom.