The Recordset object is an essential component in Access development, but it often trips up even experienced developers. Susan Harkins explains 12 common Recordset pitfalls you can anticipate and ...
Don't forget that EditMode applies for the current record, not for the whole recordset. You'll have to loop through the whole recordset until you either reach the end, or come across a new or edited ...