Mailing Label - Fill Sheet

[seb2]

To allow the user to print mailing labels for either 'all states' or '1 state' I have a form that has option buttons for each item. I also have a combo box (lists all states) which must have a selection made if for 2nd Option (1 state).

The report I've created to populate with either selection seems to be working fine EXCEPT that when 1-State is selected it only prints 1 Mailing Label.

My question is: How can I have the 1-State selection populate an entire sheet of labels. (20 labels)???

Your assistance is greatly appreciated!

 

[parbar]

One in-elegant way I've done this is to use a macro to run an append query to append the record that contains the information for the label to a temporary table. Set the macro to repeat 20 times so you have the 20 records that the report needs to print all 20 labels. Then make sure to clear all the records from the temporary table so it is ready for the next time you use it.