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


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q202135
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

When you select a Group Filter control on a data access page, the Promote button on the toolbar is unavailable (is dimmed). If you manually move the Group Filter control from one section of the page to another, you may receive the following error message:
You can't move the Group Filter control to another section. Delete the Group Filter control from the current section and create it in a different section.

CAUSE

You can only promote bound controls on a data access page; the Group Filter control is not a bound control.

RESOLUTION

Create the Group Filter control in an existing band of a grouped 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.
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbDAP kberrmsg kbprb KB202135
©2004 Microsoft Corporation. All rights reserved.