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


The information in this article applies to:

  • Microsoft Access 2000
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.

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.

REFERENCES

For additional information about group filter controls, click the article numbers below to view the articles in the Microsoft Knowledge Base:

200209 ACC2000: Caption Section of a Data Access Page Is Visible Only When the Group Is Expanded

201011 ACC2000: How to Add a Group Filter Control to a Data Access Page

Modification Type:MinorLast Reviewed:7/16/2004
Keywords:kbDAP kbprb KB202375
©2004 Microsoft Corporation. All rights reserved.