Canceling Pending Editing Changes on Bound Controls in VB6

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 data.

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:

adcEmployees.Recordset.CancelUpdate

See Also

• Setting Up the ADO Data Control

• The ADO Data Control's EOFAction and BOFAction Properties

• Binding VB Controls to the ADO Data Control's Recordset

• Adding Records With the ADO Data Control

• Editing Existing Records With the ADO Data Control

• Programming Other Actions on the ADO Data Control's Recordset

• The ADO Control's Error Event

• Other Events of the ADO Data Control