Record Source Step

In the Record Source step of the Data Form Wizard, you choose the fields that you want to bind to the controls on the form.

To specify the bound fields

  1. From the Record source drop-down list, select the name of a table or query that contains the fields you want to bind.

  2. The Available fields list contains the fields in the specified table or query. The Selected fields list contains the fields that will be bound to your form, in the order they are listed. Use the following buttons to move fields between the two lists:
    Button Description
    > Moves the selected field in the Available Fields list to the Selected Fields list. The selected field will be bound to a control on the form.
    >> Moves all fields from the Available Fields list to the Selected Fields list. All fields will be bound to controls on the form.
    < Moves the selected field in the Selected Fields list to the Available Fields list. The selected field will not be bound to a control on the form.
    << Moves all fields from the Selected Fields list to the Available Fields list. No field will be bound to a control on the form.

    Note   The Data Form Wizard will add a single-column list of bound controls to the form, based on the order of the fields in the Selected Fields list. To change the order of a field, select the field in the list and click the up arrow button or the down arrow button.

  3. To sort the data that will be displayed by the form, select a field from the Column to sort by drop-down list.

Click Next to add additional controls to the form.