Setting Printer when Printing Report

[russ0670]

I want 1 button to print about 10-20 reports on 1 click.



I have placed VBA on the button to open each report, print then close.

DoCmd.OpenReport "maintenancepayments", acViewPreview, "", "", acNormal
    DoCmd.RunCommand acCmdPrint
    DoCmd.Close

The problem I have is that each report opens the print dialogue box asking which printer to print to.

Does anyone know a way to stop this happening and get all to print to a specific or default printer.

I have tried setting page options on the report to select default printer but it still shows the print dialogue box.

[RuralGuy]

Have you tried just:
DoCmd.OpenReport "maintenancepayments"
...instead of:
DoCmd.OpenReport "maintenancepayments", acViewPreview, "", "", acNormal

[russ0670]

Thanks that did it.

[RuralGuy]

Glad we could help.