Not sure if I understand correctly, but I would probably try to make a loop,
calling the report with an openargument passing the number (newer access
versions only).
Alternatively make an unbound textbox on your form, and change the value
every time before you print the report. In the report reference this control
with something like
=Forms("FormX")![FieldY]
Alternatively, make a public variable in a module (not a form module) and
fill that from your form, and read that from your report (inserting it in
the appropriate place).
Good luck,
Bas.
"Saintor" <sa******@REMOVETHIShotmail.com> wrote in message
news:C_********************@wagner.videotron.net.. .
But you won't get an incrementing number on each copy.
<pi********@hotmail.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...
Saintor wrote: I have a record with with a quantity value. I have to print one
record for each quantiy with a counter, incrmementing on each copy. I wan't to
avoid to use many docmd.openreport instructions.
I succeeded by creating a temporary table, adding by code the job
number and the cumulative quantity value. But I am not satisfied. Is there a
way to do this without a temporary table, from within the report's code
only? TIA.
One of the arguments of PrintOut is the number of copies you want to
print... just pass that in your print command.