MS Access - Generating Multiple Reports (PDF Invoices)

Generating multiple reports. Generating an invoice for each customer. Uses a Main Form to run a Record Set Loop (RSL) the record set loop loops through the SQL statement. The SQL statement is rendered unique by a value collected from the field. The SQL statement gets passed into the forms Public Custom Property. The code opens the Report. The reports Open Event extracts the SQL Statement from the Forms Public Custom Property. The SQL Statement is then passed into the Reports Record Source. https://www.youtube.com/watch?v=Tl-O3DabPz8