Update query vs. loop through recordset

[R Fourt]

When updating a group of records (50 -100) is it preferable to use an update
query or create a recordset and loop through each records.

In my case, I'm updating two fields, a date and a logical. I've been using
an update query based on criteria pulled from variables at runtime. However,
it appears that some records are skipped from time to time.

Data integrity is the key issue here. The sub is run when a report_close
event fires. The user prints the report and then is prompted to update the
records.

 

[Allen Browne]

The update query should be easier to create and maintain, and marginally
more efficient, so would be my preference. Both approaches should be
reliable.

If you are experiencing issues with the Update query approach, don't turn
SetWarnings off, but use Execute with dbFailOnError so you know if there is
any problem. Details in:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html