ACC: GP Fault Changing RecordSource on a Filtered Datasheet

• Microsoft Access version 1.0, 1.1, 2.0

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.

MORE INFORMATION

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" (without quotation marks) 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" (without quotation marks).

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.

REFERENCES

For more information about applying filters, search for "Apply Filter/Sort," and then "Edit Filter/Sort, Apply Filter/Sort Commands (Records Menu)" using the Microsoft Access Help menu.