Allows you to choose the record source and fields within the record source to display in the grid used for the detail section of the form.
Lists available record sources in the database you chose.
Lists the available fields in the selected record source.
Lists the fields to add as columns in the grid used to display the details information.
Buttons are provided to move items between the Selected Fields list and the Available Fields list, as well to change the order of the fields in the grid. The following shows each button and its meaning:
Button | Description |
Moves the selected field in the Available Fields list to the Selected Fields list. | |
Moves all of the fields in the Available Fields list to the Selected Fields list. | |
Moves the selected field in the Selected Fields list to the Available Fields list. | |
Moves all of the fields in the Selected Fields list to the Available Fields list. | |
Changes the order of the fields in the grid. Each time you click the button, the selected field in the Selected Fields list moves up one position. | |
Changes the order of the fields in the grid. Each time you click the button, the selected field in the Selected Fields list moves down one position. |
Specifies the field you want to use for sorting. This can be any field in the selected record source and is not limited to the fields selected for display.