How to specify quantity of labels to print using form data?

S

Sheri Salomone

I have a form that collects a string and a number, I want to print a page of
avery labels , the exact qty as collected in my form. How can I teel the
report to do that?
 
A

Allen Browne

See:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

The article assumes you have a field that indicates the quantity in each
record, but you could adapt it to read the quantity from a text box, such
as:
[Forms].[Form1].[Text0]
 
D

Duane Hookom

You can create a table of numbers (tblNums) with a single, numeric field
(Num) and add values from 1 to your maximum qty.
Add this table to your report's record source and don't join it to any other
table.
Add the Num field to the grid and set the criteria to
<=Forms!frmYourForm!txtYourQty
 
Top