Passing parameters to a report (1 Viewer)

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

Use the openargs argument on the open of the report
https://docs.microsoft.com/en-gb/office/vba/api/Access.Form.OpenArgs


HTH

Are these full page labels or do you need to print multiple labels per page?
IF full page, you can call the report or sub-report N number of times per record.
IF NOT full page, you may want to add a table to your front end as a temporary queue for printing. Add N number of records to this temporary table for each real record, print your labels, then delete all entries in the temporary table. You won't need to worry much about bloat as a new copy of the front end won't have it.