Spread Designer

Notes:

To set data-binding properties, the Spread Designer view must be the active view. You cannot set data-binding properties for a sheet that you open in the Spread Designer (that is, by choosing Open from the File menu).
If you bind columns to data fields using the Spread Designer and then change the record source for the data control, you must refresh the data control (for example, run your project) before resetting data fields with the Spread Designer. Unless the data control is refreshed, the new data fields will not be reflected in the Spread Designer.

Follow the steps listed for Connecting to a Database Using Default Settings to bind the sheet to a database.
From the Sheet menu, choose Data Binding.
The Data Binding dialog box appears:
In the Data Binding dialog box,
1. To move through records in the sheet independently of records in the database, clear the Inform Data Control on Active Row Changes check box.
2. To manually save modified sheet records to the database,
  1. Clear the Automatically Save Data check box.
  2. At run time, call the DataSave method.
3. To manually enter data from the database into the sheet,
  1. Clear the Automatically Fill Data check box.
  2. At run time, load data in the sheet, using your application.
4. Choose the OK button.