Autogenerate records button

[Kyriakos]

Hi to everyone. I have this form which is used to insert specimen data. The form consists of certain combo boxes, fields etc. and works fine for individual insertions. The problem is that when I have to insert tons of data on which their only difference is their serial number (which is in this form 1/2007, 2/2007, 3/2007) i will have to manualy start passing all the data for all the records. Is there a way to insert on form a button which at first will prompt me how many records should it generate and at the same time assign each record for a unique serial number, but keep all the other data the same (as I will input at the first one)?

Sounds tricky? Help is more than welcome....

Thanks,
Kyriakos

 

[pbaldy]

Possible, and not all that tricky. Open a recordset on the destination table, use InputBox to get your count, and a For/Next loop using that value. Inside the loop, use AddNew to create new records.