Cancels any changes made to the current record or to a new record prior to calling the Update method.
recordset.CancelUpdate
The recordset placeholder is an object variable representing an open Recordset object.
Use the CancelUpdate method 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 you call the Update method unless the changes are either part of a transaction that you can roll back with the RollbackTrans method or part of a batch update that you can cancel with the CancelBatch method.
If you are adding a new record when you call the CancelUpdate method, the record that was current prior to the AddNew 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.