See Wayne's suggestion - I found this and implement it. Works great for my
current need.
Another simple solution to produce multiple copies is to create a table
(tblPrintCopies) with a single integer field. Add one record for each copy
required (1,2,3,4,5 etc). Add this table to the recordsource of the report
with no joins to any other table. When the recordsource query is run,
because a relationship between tblPrintCopies and the other table(s) cannot
be established the query will produce a line for each entry in
tblPrintCopies. So if tblPrintCopies contains 5 records, the recordsource
will produce 5 records for each "true" record in your other tables, as such
when printed, the report will generate 5 copies.
If you want to actually show a copy description in your report, instead of
using integers in tblPrintCopies use a text field and enter records for
"Original", "File Copy", "Customer Copy" etc. Drag this field into the
recordsource and bind a control on your report to this field. When printed
each
copy will be identical except for the copy description field.
Wayne Gillespie
Gosford NSW Australia
You can't. That's not a property of the report.
You could create a form that uses VBA to ensure that two copies are printed
when the user clicks on a button, but if they go to the report through the
database window and open it that way, it's not going to print two copies
automatically.
[quoted text clipped - 3 lines]
