Form Step

In the Form step of the Data Form Wizard, you specify the name of the data-bound form as well as the layout of the form.

To specify form details

1. To change the name of the form, edit the text in the Form name box.
   
   
2. Under Form layout, select one of the following options:
   • Single record   (Default) The form displays one record at a time. Each non-boolean field in the database is bound to an Edit control; boolean fields are bound to CheckBox controls. A Label control is associated with each bound control and displays the name of the field.
     
     
   • Grid (Datasheet)   The form displays multiple records in a DataGrid control.
     
     
   • Master/Detail   The form displays data from two related tables (or queries), typically having a one-to-many relationship. The form displays one record at a time from the master table and multiple records from the detail table in a DataGrid control.
3. Under Database Connection, select one of the following options:
   • Controls   (Default) The form uses an ADO DataSource control to access your database. The DataSource control is compatible with the Forms Designer; if you want to change the property settings of this control after the wizard creates the form, you can make the modifications in the Forms Designer. (The DataSource control is a nonvisual control that is displayed only when your form is in design view; it is not displayed when your form is run.)
     
     
   • Code   The form uses the ADO Connection and Recordset components to access your database. These components are not supported by the Forms Designer; they can be used only in code.
4. Click Next to specify the record source for the bound controls.