ACC2002: Shortcut Menu for Subform PivotTable Does Not Show All Items (287468)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q287468
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 right-click a PivotTable in a subform, the shortcut menu may not show all of the items that you expect to see.

CAUSE

This behavior can occur if you perform filter operations on the main form before right-clicking the PivotTable to display the shortcut menu.

RESOLUTION

To work around this issue, click any control on the main form before you return to the subform PivotTable to display the shortcut menu.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

This behavior occurs when you click the subform PivotTable and open the Filter By Form dialog box without first clicking a control in the main form, and then you apply the filter and right-click the subform PivotTable again before clicking a control in the main form.

If you click a control in the main form under either of the following conditions
  • before you open the Filter By Form dialog box

    - or -
  • before you right-click the subform PivotTable
this behavior does not occur.

Steps to Reproduce the Problem

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

  1. Open the sample database Northwind.mdb.
  2. Close the Main Switchboard form that opens during startup.
  3. On the Insert menu, click Form.
  4. In the New Form dialog box, click Form Wizard, and then click OK.
  5. In the Tables/Queries box, select the Customers table.
  6. Add CustomerID, CompanyName, and ContactName to the Selected Fields list.
  7. In the Tables/Queries box, select the Orders table.
  8. Add OrderID and OrderDate to the Selected Fields list, and then click Next.
  9. View the data by Customers, select the Form with Subform(s) option, and then click Next.
  10. Select PivotTable layout for your subform, and then click Finish.

    The form should open with a subform in PivotTable view.
  11. Click the subform, and then click Field List on the View menu.
  12. From the PivotTable Field list, drag OrderDate to the Drop Row Fields Here area, and then drag OrderID to the Drop Totals or Detail Fields Here area.
  13. Right-click the subform PivotTable and notice the items on the shortcut menu.
  14. On the Records menu, point to Filter, and then click Filter By Form.

    The main form should switch into Filter by Form mode.
  15. In the CustomerID box, type ALFKI.
  16. On the Filter menu, click Apply Filter/Sort.

    The main form should be filtered to show only the customer record for Alfred Futterkiste.
  17. On the Records menu, click Remove Filter/Sort.
  18. Right-click the subform PivotTable.

    Notice that the shortcut menu contains only the Copy, Sort, and Properties items.
Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbbug kbnofix KB287468
©2003 Microsoft Corporation. All rights reserved.