I have a main form and when the clerk is ready to input the data to the Subform I need it to create an exact number of new records (let's say 5).
The main form name is [frm_Reporting]
The subform name is [frm_Reporting_Details]
The subform's keyID field is [RptgDetails_ID] from table [ReportingAmt]
I have set a static number of lines to be created field for setting the exact number of lines that are always needing to be created in table [Valid_Registers] in the field [NbrOfMach]