ACC2000: You Cannot Promote a Group Filter Control on a Data Access Page

MORE INFORMATION

A Group Filter control is a drop-down list box with a Select Distinct clause, sorted in Ascending order for a given field in the section's recordset. The Group Filter control controls currency for that level of the hierarchy and, by default, the Group Filter control has no value. This means that when you create a band with a Group Filter control on it, no records are available until the user selects a value from the drop-down list box. At this point, that level of the hierarchy is populated, and any children it may have are also populated.

The Demote button on the toolbar works on an entire section. Therefore, if you select anything in a parent section, the Demote button is enabled.

Steps to Reproduce the Behavior

1. Open the sample database Northwind.mdb.
2. In the Database Window, click Pages under Objects, and then click New.
3. In the New Data Access Page dialog box, click Page Wizard, click Customers in the Choose the table or query where the object's data comes from box, and then click OK.
4. Move CustomerID and CompanyName from the Available Fields list to the Selected Fields list, and then click Finish.
5. In the toolbox, click the Dropdown List control to select the control.NOTE: If the toolbox is not displayed, click Toolbox on the View menu.
   
   
6. With the Dropdown List control selected in the toolbox, click the Country field from the Customers table in the field list, hold down the right mouse button, and then drag the Country field into the Header: Customers section of the page.
7. On the shortcut menu, click Group Filter control.
8. Right-click the Country control. Note that Promote is unavailable on the shortcut menu and on the toolbar.