Prompt for Printer When Report Opens

[EddieN1]

How do I tell the Report to prompt for a printer instead of automatically going to the default printer?

Thanks, Eddie

[June7]

Open the report in PrintPreview and code opens printer dialog.
Bing: Access report printer dialog
http://answers.microsoft.com/en-us/o...e-4a95438c1104

[EddieN1]

I found it... instead of using a Docmd.OpenReport... instead, use...

DoCmd.SelectObject acReport, "rpt_Name", True ' True means open from Navigation pane

On Error GoTo ClickPrintCancel
DoCmd.RunCommand acCmdPrint

Exit Sub

ClickPrintCancel:

MsgBox "Print Request Cancelled", vbOKOnly, "Print Cancelled"

End Sub

Hope this helps someone... Eddie

[June7]

Interesting, never used that. Probably because doesn't allow sending filter criteria to the report.

Glad you found solution and shared it.