I'm developing an Access 2002 application with VBA/DAO where a function based on a recordset is constantly changing its own recordset, adding new records needed in further parts of the same function.

Now - that's exactly what it refuses to do.

version 1: after an update, I add recordset.requery --- with no effect.
version 2: after an update, I close the recordset, write the new record in a temp-table, update from there and open my recordset again, proceeding with the next record. --- Still with no effect. The new records are just ignored and cause errors furtheron.

Has anyone a better idea?