The CancelUpdate method cancels changes made to a record of a Recordset object, or the Fields collection of a Record object, before calling the Update method.
This method is used to cancel any changes made to the current record or to a newly added record. This method can only be called before the Update method of the Recordset is called.
This method is used to cancel any changes (insertions or deletions) of Field objects.