I'm trying to work out how to print a number of labels depending on data in my table. I have a report set up using a select query, but how do I send data through VBA to the report.
I have a table "tblCartons" which has multiple records linked to my table "tblShipLists" by the primary key (autonumber)
I can write the code to work out which label number I'm trying to print and how many total labels I need (i.e. 1 of 4) but how do I pass the data to the report or query so I can use it as a printable field on the report?
Thanks in advance
I have a table "tblCartons" which has multiple records linked to my table "tblShipLists" by the primary key (autonumber)
I can write the code to work out which label number I'm trying to print and how many total labels I need (i.e. 1 of 4) but how do I pass the data to the report or query so I can use it as a printable field on the report?
Thanks in advance