Numbering Labels

J

JB

I have a form that the user uses to select several items associated with a
particular Job Number.

If Item A has a quantity of 25, I need to print 25 labels 1 of 25, 2 of 25,
3 of 25 ......
If Item B has a quantity of 5, I need to print 5 labels 1 of 5, 2 of 5, 3 of
25 ..........

The number of Items, and quantities, will not always be the same.

The user needs to click a button just once to print all labels.

Could somebody point me in the right direction to print numbered labels for
several records?

Thanks
 
K

Klatuu

Not hard. If you open the property sheet for the detail section, you can set
the Force New Page property to After Section. Then you can add the page
numbers and number of pages to number the labels. Where you find it depends
on your version of Access.
 
R

Roger Carlson

J

JB

Thanks for your help.

Roger, I successfully modified your code. It works perfectly.

Thanks again
 
Top