Do new records have to be inserted manually?

[dogman01]

I have a main record form with a subform to record events built into it. If I am in the subform and want to add a new record I either have to click the New Record button or tab through thte fields to the end then a blank record appears. Seems there should be a way to have the subform insert multiple blank records at a time, is there?

 

[pbaldy]

Sure, but not directly through the form. You could execute an insert query or use a recordset to insert multiple records into the table.

 

[wazz]

but inserting blank records violates the rules, no?

 

[pbaldy]

Sure, but aren't rules made to be broken?

I've actually done it a couple of times for ease of data entry. When a form loads I insert records for the selected employee for each of the possible rates they might use, with zero quantities. The data entry person can just tab down the quantity column filling in quantities for whatever rates were actually used. When the form closes, I delete any records with zero quantities. If I wrote that app today I might use a temp local table instead, but this app has worked well for years.

 

[wazz]

Sure, but aren't rules made to be broken?

but of course.