Making multiple Invoices automatically

Question

I have a form named "RenewalForm" with a query that is not updatable where customer's records that are up for renewals show up.
I have a code under "ShipName" in that form that when I click, it does the invoice and prints it.
Is there a way that I can do all of them without having to click on "ShipName" for each?

Thank you.

Answer 1

I want to thank you for all of your time in trying to help me, I am giving up in trying to MAKE and PRINT multiple renewal invoices with a single click.

Is over my head.

I tried to use append query for inserting the values into the tables but there are 2 tables involved and also in one of them I need to add a unique invoice number which in my original code goes like this: DMax("[OID]", "ShipAddress") + 1

Thanks again.