How to print multiple copies without collating from a macro.

B

Beverly76

I have a report that is finished. I need to print three copies of each sheet
(not collated). I know how to do this from the menu. But I want to run the
print command from a macro. I am using a swithboard and I would like for the
user to be able to push one button and have the report print out as I
mentioned - whether it be a macro or a runcommand...doesn't really matter. I
just don't know the command.
 
D

Duane Hookom

One possible method is to create a table of numbers with values 1-3
tblNumbers
Num 1, 2, 3
Add this table to your report's record source without any join lines. This
will create three copies of every record in your query. Setting your primary
sorting on the Num field will print three copies of your report.
 
Top