Inserting multiple records into a table

[JIMB]

Is it possible to loop through a record set and loading a new row to a table without getting the message " you are about to append 1 row'

I want to loop through 4,000 records do some calcualtions and load that into a new row in a different table.

Thanks,

 

[pbaldy]

It sounds like you're using RunSQL. You can switch to CurrentDb.Execute or use SetWarnings before and after your insert.

 

[JIMB]

Paul,

Thanks so much. CurrentDb.Execute did what i wanted.

 

[pbaldy]

No problem.