Input Box 1

[dvannoy]

I have a Label that is printed by three different departments. but the number of copies are never the same. What i want to do is, have a input box pop-up and ask them how many copies would they like...Based on there answer thats how many copies get printed...can anyone assist me in this???

Thanks

 

[LonnieJohnson]

Try this in the module of your report:

Private Sub Report_Activate()
DoCmd.PrintOut acPrintAll, , , , InputBox("How Many Pages&quot
End Sub ljprodev@yahoo.com
Professional Development
MS Access Applications