PRA: GP Fault Closing Subform in Datasheet View

Article ID: Q106289
Creation Date: 04-NOV-1993
Revision Date: 19-SEP-1996

The information in this article applies to:

Microsoft Access version 1.0

SYMPTOMS

You receive a general protection (GP) fault when you close a form that contains a subform that is being displayed in Datasheet view.

CAUSE

A macro that switches the subform between Datasheet and Form view is assigned to the OnDblClick property of the subform.

RESOLUTION

Use the View menu to view the subform in Datasheet view, or switch the subform to Form view before closing the form.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access version 1.0. This problem no longer occurs in Microsoft Access version 1.1.

MORE INFORMATION

Steps to Reproduce Problem

WARNING: Reproducing this problem will cause a GP fault on your computer. Make sure to save any open work on your computer before you reproduce this problem.

Open the sample database NWIND.MDB.

Create the following new macro:

      Macro Name   Action
      -----------------------
      Switch       DoMenuItem

      Switch Actions
      --------------------------
      Menu Bar: Form
      Menu Name: View
      Command: Subform Datasheet

Open the Categories form in Design view. Double-click the Categories Subform subform to open it in Design view.
Set the subform's OnDblClick property to the Switch macro.
Close the subform, and then view the Categories form in Form view.
Double-click the Product ID field on the subform to switch it to Form view. Double-click the field again to switch the subform to Datasheet view.
Close the Categories form.

A GP fault will occur.

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.