Command button to print report

[Shimshee]

Hi,
I use a command button to print a report but when I click the button
it does not ask me how many copies of the report I want to print. Is
there any way to make the command prompt me and ask how many copies to
print?
These are labels with barcodes for boxes.
Thanks

 

[Carl Rapson]

Hi,
I use a command button to print a report but when I click the button
it does not ask me how many copies of the report I want to print. Is
there any way to make the command prompt me and ask how many copies to
print?
These are labels with barcodes for boxes.
Thanks

In the Click event of your button, use the InputBox function to prompt for
the number of copies, then set up a loop to call DoCmd.OpenReport that many
times.

You could open the report in Preview mode and have the user use the Print
dialog to set the number of copies.

Carl Rapson