Create a filter that finds records on a grouped data access page

1. Open the data access page in Design view.
   
   
2. If the fields you want to display aren't in the section already, add the fields to the page as bound HTML controls, or add the fields as bound text boxes. Make sure you add the field you want to use to filter records.

   Notes

   • The page will load faster in Page view and in Internet Explorer if you use bound HTML controls.
     
     
   • If there is no section on the page, add an unbound section.
3. Make sure the control bound to the field whose values you want to use to filter records is selected.
   
   
4. Do one of the following:
   • To group just on that one field, click Promote on the toolbar.
     
     
   • To group on the whole table or query that contains that field, click Group By Table on the toolbar.

   Microsoft Access adds a group header with an expand control and a record navigation section with a record navigation control. If you grouped on one field, Access moves the control you grouped on to the group header. If you grouped on a table or query, Access moves all the controls, including controls bound to fields that are in that table or query and controls bound to Lookup fields, to the group header.

5. Click the Dropdown list tool in the toolbox.
   
   
6. In the field list, use the right mouse button to drag the field whose values you want to use to filter records to the group header you created in step 4.
   
   
7. On the shortcut menu, click Group Filter Control.

The following steps are optional. They remove features that were added by default for a grouped page but aren't necessary when using the group filter control.

8. Select the expand control in the header that contains the filter control, and then press DELETE.
   
   
9. Select the record navigation section for the group level that contains the filter control, and then press DELETE. Access deletes the section and the navigation control that it contains.
   
   
10. Customize the record navigation control for the lower group level. For example, hide the buttons that add and delete records.

Notes

• If the group header also contains a control that calculates a total or other aggregate, when you choose a group from the group filter, the calculated control displays the correct total or other aggregate for that group of records.
  
  
• You can have multiple group levels, each with one group filter. For example, you can create a group filter for a Country field, then in the next lower group level, create a group filter for the City field, and so on.