Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

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 Ctrl 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