This form illustrates how to print multiple labels which matches the value of the record in the form. The code is behind the 'Print Report' button and basically creates a query: 'qryMyQuery' which is the Record Source for the report and then opens the report in preview mode

To print multiples, the sub 'CreateLabelNum' deletes then fills the table 'tblLabelNums' with the number of records in the combo box. This table is then joined to the main table WITHOUT indicating a Join field. This creates a cartesian product which will join each selected row with a row in the tblLabelNums table.