I want access to ask for a number then use that number to print la

[thudson]

I have a table with all of the parts nessicary to build a component. I want
the operator to enter the work order number and quantity required. I want
Access to print out labels which contain all of the parts in my table and
print the work order number on each label as well as multiply the quantity
the operator entered by the quantity of each part in the table.

 

[mray29]

So you want a user to enter a Work Order #, Component, and Quantity, and have
the label print out part numbers and quantities? You can build a form with
three text boxes on it and have the user fill out WO#, qty and Component. You
then design a query that uses these entries to filter on the part table and
calcualte the quantities. Then base a report for labels on that query.