When you call .Update on a DAO Recordset, the current record’s buffer is written to the database and may be repositioned or refreshed — depending on the recordset type and underlying query.
This means that the record you were editing might no longer be current, or DAO needs to requery to see...