Form Wizard - Add Sub-form Fields

Specify the table or query you need to create the sub-form, and which fields you wish to include in the sub-form.

To access this command...

Click Use Wizard to Create Form in a database file window.

Tables or queries

Specifies the table or query for which the sub-form is to be created.

Available fields

Lists the names of the data base fields in the selected table or query. Click to select a field or hold down the Shift or the key while you click to select more than one field.

>

Click to move the selected field(s) to the box that the arrow is pointing to.

>>

Click to move all fields to the box that the arrow is pointing to.

<

Click to move the selected field(s) to the box that the arrow is pointing to.

<<

Click to move all fields to the box that the arrow is pointing to.

^

Click to move the selected field up one entry in the list.

v

Click to move the selected field down one entry in the list.

Fields in my sub-form

Displays all fields that will be included in the new sub-form.

Form Wizard - Get joined fields