ACC95: Main Form with Two-Level Nested Subforms Causes Err on NT

• Microsoft Access 7.0
• Microsoft Windows NT Server, versions 3.51, 4.0
• Microsoft Windows NT Workstation, versions 3.51, 4.0

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

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:

   An application error has occurred and an application log is being
   generated.

   MSACCESS.EXE

   Exception: access violation (0xc0000005), Address: 0x500b96e1

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.

1. Open the sample database Northwind.mdb.

2. Open the Customers form in Design view.

3. On the Window menu, click Tile Vertically so that you can see both the form and the Database window.

4. 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.

5. On the View menu, click Form.

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

7. Type T* in the Customer ID field on the Customers form.

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

9. 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.