Article ID: 158932
Article Last Modified on 7/1/2002
APPLIES TO
- Microsoft Access 95 Standard Edition
This article was previously published under Q158932
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
When you use the Filter By Form command on a form with two nested subforms, and you move between main form records, you may receive an error message similar to the following:
RESOLUTION
The only workaround is to avoid the circumstances that cause the error:
- If you use two levels of nested subforms in a database on Microsoft Windows NT, don't use the Filter By Form command.
- If you must use the Filter By Form command with two levels of nested subforms, then run the command on a computer running Windows 95.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Access version 7.0. This problem no longer occurs in Microsoft Access 97.
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.
- Open the sample database Northwind.mdb.
- Open the Customers form in Design view.
- On the Window menu, click Tile Vertically so that you can see both the form and the Database window.
- Drag the Orders form from the Database window to the bottom of the detail section of the Customers form. Because the Orders form already contains a subform, this creates two levels of nested subforms on the Customers form.
- On the View menu, click Form.
- On the Records menu, point to Filter, and then click Filter By Form.
- Type T* in the Customer ID field on the Customers form.
- On the Filter menu, click Apply Filter/Sort.
- Use the record navigation buttons at the bottom of the Customers form to move through the main form records. Note that the error occurs.
NOTE: You may have to move through two or more records to generate the error.
Additional query words: IPF msaccess exe invalid page fault watson
Keywords: kberrmsg kbbug kbfix kbusage KB158932