Multiple data entries on a form

[argsemapp]

I'm learning Access/VBA. Basically I have a form that generates a report. Right now I've got the form working for a single entry, but now I need to be able to handle multiple entries of the same type- "Alloy Name" (lookup from a combobox) and "Lot Number" (user inputs this number).

i.e. I want to have a box where user selects "How many records" (could be 1-20), then my form will appear n-times for data entry. Ultimately I want to pass the SQL lookups for all these records to the report.

What is the best way to accomplish this? It seem subforms are the way to go, but will having 20 of the same subforms on a single form cause any issues? If the subform is repeated n-times, how do I reference the different instances of the combobox/lot number?

Thanks in advance

[June7]

Not really understanding. Why would form have to be opened 20 times? Just move to a new record and enter new data. VBA code can 'carry forward' values from previous new record to the next new record by setting the DefaultValue property of controls.

Review https://www.accessforums.net/forms/r...rds-38447.html