First off, I am not a VB programmer. At my office one of our employees needed an update to an old program they use to update an Access database. The user has a form that lists different fields ...
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 ...