I know reports are for printing records, but I've built a program that's a form. Its used to print labels for different patient medications and one user may need 1 label while other user quanities will vary constantly
everything works fine except when a user clicks a print button i created using a command they either:
1. get all of the records
2. get only one thats selected
3. get whatever number i specify in building the program
or
I create a macro using the printout function and in the action arguments i have to select a number there.thats a lot to ask a user to do for every time they want to print

What I want is for the user to specify how many labels they need to print before or after they hit the print button.

please help

I would suggest a form with a listbox of names to choose from, and a text box to enter the no requried.

Download the example here http://www.microsoft.com/downloads/details.aspx?FamilyID=71db24a5-c76f-4eda-bc9a-5fac336ef7f1&DisplayLang=en

It may help