Microsoft KB Archive/202375

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

Article ID: 202375

Article Last Modified on 7/16/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q202375



Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SYMPTOMS
A Group Filter control is a special type of drop-down list box. A Group Filter control allows you to filter the records returned on a data access page, or in a section of a data access page, based on your selection. Each section of a data access page can have only one Group Filter control. If you add another Group Filter control to a section of the page that already has a Group Filter control, the original Group Filter control will be changed to an ordinary drop-down list box.



STATUS
This behavior is by design.



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:
 * 5) * Customers: CustomerID
 * 6) * Customers: CompanyName
 * 7) If the toolbox is not displayed, click Toolbox on the View menu.
 * 8) In the toolbox, click the Dropdown List control.
 * 9) 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.
 * 10) On the shortcut menu that appears when you release the right mouse button, click Group Filter Control.
 * 11) On the View menu, click Page View. Note that the data access page does not display any records.
 * 12) 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.
 * 13) On the View menu, click Design View.
 * 14) If the Sorting and Grouping dialog box is not displayed, click Sorting and Grouping on the View menu.
 * 15) Select Customers as the group record source, and note the values for the GroupFilterControl and the GroupFilterField properties.
 * 16) Repeat steps 6 through 8, but this time use the ContactName field.
 * 17) 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.
 * 18) On the View menu, click Design View.
 * 19) 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.

