You can use the CancelUpdate method of the Recordset to cancel pending changes
to the current record so that the changes just made won't be written to the underlying
The CancelUpdate method of the Recordset basically cancels a pending edit defined
by the AddNew methods or by the user's or the program's changes to contents of
fields in the record buffer. If there is no pending edit, CancelUpdate is just ignored.
The CancelUpdate method doesn't move the record pointer. An example of a call
to CancelUpdate is this: