Show All

Set or change the record source of a data access page section

You can change the record source of a section on an ungrouped page, if the record source that you want to use contains all the fields that are already on the header section. For example, if you add fields from the Order Details table, and then decide to use the Order Details Extended query instead of the Order Details table, you can simply change the property of the header section.

1. Open the data access page in Design view.
2. Double-click the section bar of the header section.
3. In the RecordSource property box, select a record source from the list.

Note  The names of the sections and the ControlSource property of the controls will be automatically updated to reflect the new record source.