Tutorials References Menu

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