This is tricky. I've used DoCmd.PrintOut acPages, 1, 1, acMedium, 3 in the on activate event of a report.
The form that executes the printing of the report has two buttons, preview and print. I want the report to print 3 copies of the report when the print button is clicked,And only preview when the preview is clicked. Each button executes the docmd DoCmd.OpenReport "rptOrders", acViewNormal and preview , respectfully. I set up a variable that is set from each button_click that initializes to 1 or 0 depending on the button. this is passed to the report and the activate event has an if statement that checks for 0 and executes the DoCmd.PrintOut acPages, 1, 1, acMedium, 3 but this doesn't work.
any ideas on how to do this effectivly.