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 CommandCtrl 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.