Command button to print report

  • Thread starter Thread starter Shimshee
  • Start date Start date
S

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
 
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
Click to expand...

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
 
Back
Top