(Q) How do I printout multiple copies of one report without having to use the
Docmd.OpenReport multiple times?
(A) Use the Printout Method of the Docmd object.
DoCmd.PrintOut [printrange][, pagefrom,
For example, if I want to print out two copies of the first page of a report, I would
DoCmd.OpenReport "rptCustomers", acViewPreview
DoCmd.PrintOut acPages, 1, 1, , 2
'Access 2.0 equivalent is Docmd Print
OR as posted by Alex Dybenko, the following method which does not require the report to
be in Preview mode.
DoCmd.SelectObject acReport, "rptCustomers", True
DoCmd.PrintOut , , , , 2