Access vba current recordset does not support updating
Whether using Record Count to check for the existence of records or to count records, you must remember the differences between DAO and ADO: Tip: Don't use Move Last with a large Recordset to check for an empty Recordset. If Record Count returns 1, you know the Recordset isn't empty.Always make sure you include a Move Next method when you mean to cycle through a set of records.Failing to move in any type of looping structure can have the same result — this isn't just a Do loop consideration.If both properties are True simultaneously, the Recordset is empty.
Tip: Including the Not operator is a matter of efficiency.
In fact, DAO and ADO use the Recordset object to represent a multivalue field.