Filtering product list to print full sheet of labels

[Mike Cooper]

Hello everyone,



I have a product query and would like to create a label for the products.
Using the label wizard prints one label for every product. This would mean some product label might never be used.
I would like to select one product from the query by entering in the product code then print a full sheet of labels for that filtered product.

If any one can help me on this problem.

Thanks

Mike

[June7]

Options:

1. write duplicate records to a 'temp' table for however many labels you want

2. VBA code that forces the record to print repeatedly in the detail section of report http://support.microsoft.com/kb/207664

I have used both methods.

[Mike Cooper]

Thanks for the advice. I used option 2 and it worked after the 2nd attempt.
Once again thanks June7.