print multiple copies of a report from a form

  • Thread starter Thread starter stalw
  • Start date Start date
S

stalw

Guest
hi
i use a command button on a form to print a report:
the code for this as we all know is:
DoCmd.OpenReport "myreport", acNormal
How do i print multiple copies of this report
Currently i am writing the above line thrice to generate 3 copies,
Is there another way
thanks
s talwalkar
 
intNumOfReports = 3

For i = 1 to intNumOfReports
DoCmd.OpenReport "myreport
Next i

Or you can use the PrintOut Method of the DoCmd Object:

DoCmd.PrintOut acPrintAll, , , , 3
 
intNumOfReports = 3

For i = 1 to intNumOfReports
DoCmd.OpenReport "myreport
Next i

Or you can use the PrintOut Method of the DoCmd Object:

DoCmd.PrintOut acPrintAll, , , , 3
 
intNumOfReports = 3

For i = 1 to intNumOfReports
DoCmd.OpenReport "myreport
Next i

Or you can use the PrintOut Method of the DoCmd Object:

DoCmd.PrintOut acPrintAll, , , , 3
 

Users who are viewing this thread

Back
Top Bottom