How to read a recordset and load data into a new table

[jimb]

I have written code in vba:
1. reads a recordset
2. does some calculations and places results in variables
3. load data into a new table.

i'm processing 4000 records and don't want to be asked if i want to update every time I read a new record.

[NeoPa]

You could try encapsulating your code within :

Call DoCmd.SetWarnings(False)
...
Call DoCmd.SetWarnings(True)