ADO CancelUpdate Method

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