Microsoft KB Archive/123086

= ACC: GP Fault Changing RecordSource on a Filtered Datasheet =

Article ID: 123086

Article Last Modified on 5/6/2003

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q123086





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

When you apply a filter directly from the Filter window to a form open in Datasheet view, and then try to change the form's record source, you may receive a general protection (GP) fault error message.



RESOLUTION
Close the Filter window before applying the filter to the form.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Access versions 1.x and 2.0. This behavior no longer occurs in Microsoft Access version 7.0.



Steps to Reproduce Problem
CAUTION: Following these steps will cause a GP fault on your computer. Make sure to save and close any open work before following these steps.


 * 1) Open the sample database NWIND.MDB.
 * 2) Select the Customers table in the Database window and then choose Copy from the Edit menu.
 * 3) From the Edit menu, choose Paste. Type Cust in the Table Name box, and then choose the OK button.
 * 4) Open the Customers form in Datasheet view.
 * 5) From the Records menu, choose Edit Filter/Sort.
 * 6) In the Filter window, drag the Customer ID field from the field list to the Field row in the first column.
 * 7) In the Criteria row in the first column, type ALFKI.
 * 8) Click the Apply Filter/Sort button on the toolbar. Do not close the Filter window.
 * 9) View the form in Design view. Change its RecordSource property from the Customers table to the Cust table. You receive a GP fault error message.

