ActiveX

To specify sheet and database interaction

1. Follow the steps listed for Connecting to a Database Using Default Settings to bind the sheet to a database.
2. To move through records in the sheet independently of records in the database, set the DInformActiveRowChange property to False.
3. To manually save modified sheet records to the database,
   1. Set the DAutoSave property to False.
   2. At run time, call the DataSave method.
4. To manually enter data from the database into the sheet,
   1. Set the DAutoFill property to False.
   2. At run time, load data in the sheet, using your application.