print multiple copies of a report

S

SUZYQ

Is there a way to control the number of copies that a report prints?

Currently I'm using the docmd.openreport "rptName" code. However, I
need the users to get two copies of the report when it prints.

My workaround is to just put that code twice.

Is there a better way?

Thanks!
 
F

fredg

Is there a way to control the number of copies that a report prints?

Currently I'm using the docmd.openreport "rptName" code. However, I
need the users to get two copies of the report when it prints.

My workaround is to just put that code twice.

Is there a better way?

Thanks!
Click to expand...

Here is one way. Look up the methods in VBA Help.

DoCmd.SelectObject acReport, "rptName", True
DoCmd.PrintOut acPrintAll , , , , 2
 
Top