ACC2000: Data Access Page Section Can Have Only One Group Filter Control

MORE INFORMATION

Steps to Reproduce the Behavior

1. Open the sample database Northwind.mdb.
2. In the Database window, click Pages under Objects, click New, click Design View, and then click OK.
3. If the field list is not displayed, click Field List on the View menu.
4. Drag the following fields from the field list to the page:
   • Customers: CustomerID
   • Customers: CompanyName
5. If the toolbox is not displayed, click Toolbox on the View menu.
6. In the toolbox, click the Dropdown List control.
7. With the Dropdown List control still selected in the toolbox, right-click the City field from the Customers table in the field list, hold down the right mouse button, and then drag the City field to the data access page.
8. On the shortcut menu that appears when you release the right mouse button, click Group Filter Control.
9. On the View menu, click Page View. Note that the data access page does not display any records.
10. Select a value from the City field, the group filter control. Note that when you select a value, all matching records are displayed on the data access page.
11. On the View menu, click Design View.
12. If the Sorting and Grouping dialog box is not displayed, click Sorting and Grouping on the View menu.
13. Select Customers as the group record source, and note the values for the GroupFilterControl and the GroupFilterField properties.
14. Repeat steps 6 through 8, but this time use the ContactName field.
15. On the View menu, click Page View. Note that if you select a value from the City field, the page is not populated with associated records as before. However, if you select a value from the ContactName field, which is now the sole Group Filter control, the page is populated with records that match the selected Contact.
16. On the View menu, click Design View.
17. In the Sorting and Grouping dialog box, select Customers as the group record source, and note that the values for the GroupFilterControl and the GroupFilterField properties have been changed to reflect the new Group Filter control.