Editing Existing Records With the ADO Data Control in VB6

Any time the user edits controls that are bound to the Data Control, the user has changed information in the copy buffer.

Changes to records will save automatically when a user or the programmer moves the ADO Data Control Recordset's record pointer away from the current record by any means, including the following:

• Using the Find method

• Resetting the Recordset's bookmark—even if it's only to set the Bookmark back to the current record

• Using any of the Move methods on the Recordset

• Adding another record

• Clicking one of the four arrow buttons on the ADO Data Control

This is because moving the record pointer writes the contents of the record buffer out to the underlying data.

You also can save changes programmatically by calling the Update method of the Recordset or the UpdateRecord method of the ADO Data Control.

You can take more control of whether changes are saved by writing code in the Will event procedures, as described later.

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

• Canceling Pending Editing Changes on Bound Controls

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

• The ADO Control's Error Event

• Other Events of the ADO Data Control