ADO CancelUpdate Method
Complete Recordset Object Reference
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.
Recordset object
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.
Record object
This method is used to cancel any changes (insertions or deletions) of Field objects.
Syntax
objRecordset.CancelUpdate
objRecord.Fields.CancelUpdate
Complete Recordset Object Reference