Article ID: 201011 - View products that this article applies to.
This article was previously published under Q201011
This article has been archived. It is offered "as is" and will no longer be updated.
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).
This article shows you how to create and use a Group Filter control on a data access page. The example in this article uses the sample database Northwind.mdb.
A Group Filter control is a drop-down list box with a Select Distinct clause, sorted in Ascending order for a specified field in the section's recordset. The Group Filter control controls the current recordset for that level of the hierarchy. By default, the Group Filter control has no value. This means that when you create a section with a Group Filter control on it, there are no records available until you select a value from the drop-down list. At this point, that level of the hierarchy is populated, and any children it may have are also populated.
This type of control can be compared to a combo box on a form that finds a record on that form based on the value selected in the combo box. The control itself is not bound to the underlying recordset; it merely provides you an interface for selecting records.
Each group or level of a data access page can contain a single Group Filter control. When you place a second Group Filter control in a section, the original control is "demoted" to a drop-down list. The properties that determine which drop-down list in a section, if any, are to be implemented as a Group Filter control are Group Filter Control and Group Filter Field. Although you can use a wizard to help you create a Group Filter control, you can also set these properties manually. You can access both properties through the Sorting and Grouping dialog box.
To create a Group Filter control: