The CancelUpdate method on a Recordset object cancels any changes made to the current record or to a new record prior to calling the Update method.
recordset.CancelUpdate
None.
The CancelUpdate method is used to cancel any changes made to the current record or to discard a newly added record. You cannot undo changes to the current record or to a new record after the Update method is called unless the changes are part of a batch update that you can cancel with the CancelBatch method.
If you are adding a new record when the CancelUpdate method is called, the record that was current prior to the AddNew method call becomes the current record again.
If you have not changed the current record or added a new record, calling the CancelUpdate method generates an error.