ADO Data Control

The ADO data control presents a fast and easy way to create a bound form by providing built-in functions that define, navigate, display, add to, and update the records in a recordset. The resulting form makes it easy for a user (non-developer) to maintain records. Although the data control defines the recordset, you’ll still need a control for each field to automatically display the bound records.

Figure A

Figure A displays a simple form with several bound controls. The data control at the bottom of the form contains four navigation buttons. These buttons, from left to right, allow you to move to the first, previous, next, and last records in the form’s recordset. If you update a record, VB will save that change when you move to another record. If you close the form before moving to another record, VB won’t save changes you’ve made to the current record.