I need to print some labels for a product we manufacture and am having a couple problems....
1) When I go from the form to the report (label), how can I tell it the number of labels I want it to print?
2) The Qty often needs to change for the last label.... How can I override what it pulls from the query it does based upon the record reference I send it.
stLinkCriteria = "[CustOrderID]=" & Me![CustOrderID]
DoCmd.OpenReport stDocName, acViewNormal, , stLinkCriteria
All is fine except for that last label....where the Qty may need to be changed. I don't want the employees changing the data in the main tables for this last label as I can't guarantee them changing it back to it's original value.
1) When I go from the form to the report (label), how can I tell it the number of labels I want it to print?
2) The Qty often needs to change for the last label.... How can I override what it pulls from the query it does based upon the record reference I send it.
stLinkCriteria = "[CustOrderID]=" & Me![CustOrderID]
DoCmd.OpenReport stDocName, acViewNormal, , stLinkCriteria
All is fine except for that last label....where the Qty may need to be changed. I don't want the employees changing the data in the main tables for this last label as I can't guarantee them changing it back to it's original value.
