|
|
Step 4: Add a Group Filter Control 
- Switch to Design view.
- Click Header: Customers.
- On the View menu, click Properties, click the Format tab, and set the Height property to 0.75in.
- Drag the CompanyName box and its label, its expand control, and the City box and its label to the bottom of the Header: Customers section.
- In the field list, make sure that the Customers table is expanded.
- If the toolbox is not visible, click Toolbox on the View menu.
- Click the Dropdown List tool in the toolbox.
- Use the right mouse button to drag the Country field from the field list to the top of the Header: Customers section. On the shortcut menu, click Group Filter Control.
- Note The shortcut menu does not appear unless you used the right mouse button to drag the Country field.
- While the Country box is still selected, click Properties on the View menu, and then click the Format tab.
- Set the FontWeight property to bold, and set the Width property to 1.5in.
- On the View menu, click Sorting and Grouping. Note that you cannot change the value of the DatePageSize property for the Customers group.
- Save the page and switch to Page view. Note the controls contain no data.
- Select a country from the Country box. Note that only customers in that country appear in the page. You can use the record navigation buttons to browse records, and you can click the expand indicator to view more details about a particular record.
- Note Only one record at a time is displayed in a group header that contains a group filter control. However, if you remove the group filter control, the page displays the number of records specified by the DataPageSize property of that group.
For more information about creating a group filter control, type create a filter in the Office Assistant or on the Answer Wizard tab in the Help window, click Search, and then click Create a filter for a data access page.
|