Print more than one copy

  • Thread starter Thread starter RobC
  • Start date Start date
R

RobC

I have a report that is based on a query. Is there a way to include the
number of copies I need printed to be included in the query? The query is
triggered from a command button on a form and I want to immediately send the
report to the printer without any print dialog box to pop up. But I need
the ability to change the number of copied I need at will.

Any help or suggestions would be very much appreciated.

Thanks,
 
Consider creating a table of numbers "tblNums" with a single numeric field
"Num". Add record values 1 through 100 or whatever. You can add this table
to your report's record source and don't join it to any other table. Add a
text box to your form "txtCopies" and use this in your query as the criteria
under the Num column:
<=Forms!frmYouForm!txtCopies
This will create a recordsource with multiple copies of each record.
 
Back
Top