ACC97: IPF Using Filter By Form with Linked Subform

Last reviewed: May 22, 1997
Article ID: Q168881
The information in this article applies to:
  • Microsoft Access 97

SYMPTOMS

When you use the Filter By Form command to filter a form that contains a linked subform, you may receive the following error message:

   There are too many controls on the form to allow Filter By Form.

Upon applying the filter, you receive the error message:

   This program has performed an illegal operation and will be shut down.
   If the problem persists, contact the program vendor.

When you click the Details button, you receive the following message:

   MSACCESS caused an invalid page fault in module KERNEL32.DLL.

   -or-

   MSACCESS caused an invalid page fault in module MSACCESS.EXE.

CAUSE

The subform is based on either a totals query or a crosstab query and is linked to the main form.

RESOLUTION

There are two possible ways to work around this behavior:

  • Set the subform's RecordSource property to a temporary table created with a make-table query based on the original totals query or crosstab query.
  • Use the form's other filtering capabilities to filter the data, such as Filter By Selection, or Advanced Filter/Sort.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 97. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Problem

WARNING: Following these steps will cause an invalid page fault on your computer. Make sure you save and close any open work on your computer before following these steps.

  1. Open the sample database Northwind.mdb.

  2. Open the Quarterly Orders form in Form view.

  3. On the Records menu, point to Filter, and then click Filter By Form.

    Note that you receive the message "There are too many controls on the form to allow Filter By Form."

  4. Click OK to clear the message.

  5. In the CustomerID combo box, select "ALFKI."

  6. On the Filter menu, click Apply Filter/Sort.

    Note that you receive the error:

    This program has performed an illegal operation and will be shut down. If the problem persists, contact the program vendor.

When you click the Details button, you receive the following message:

   MSACCESS caused an invalid page fault in module KERNEL32.DLL.

   -or-

   MSACCESS caused an invalid page fault in module MSACCESS.EXE.
 

	
	


Keywords : FmsSubf kbusage
Version : 97
Platform : WINDOWS
Hardware : x86
Issue type : kbbug
Resolution Type : kbworkaround


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 22, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.