ACC2000: Error When You Close a Form That Has a Combo Box That Is Based on a Parameterized Query (248904)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q248904
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

When you close a form that has a combo box that is based on a parameterized query, you may receive the following error message.

If you are running Microsoft Windows 95 or Microsoft Windows 98:

This program has performed an illegal operation and will be shut down.

If the problem persists, contact the program vendor.
When you click Details (on Microsoft Windows Millennium Edition, press ALT+D), you receive the following message:
MSACCESS caused an invalid page fault in MSACCESS.EXE at 0167:3040910b.
NOTE: The actual memory address may vary.

If you are running Microsoft Windows NT:
MSACCESS.EXE
Exception: access violation (0xc0000005), Address: 0x00000000
NOTE: The actual memory address may vary.

RESOLUTION

To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).

To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base:

245025 OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb.
  2. Create a parameterized query. From the Orders table, include the OrderID, OrderDate, and EmployeeID fields.
  3. For the EmployeeID field, click to clear the Show check box, and then add the following criteria:

    [Enter EmployeeID]

  4. Save the query as testordqry, and then run it. Type any number when you are prompted to enter an employeeID.
  5. Create a new form, and then set the following properties for the form:

    Form name: TestParamForm
    Form caption: TestParamForm
    Recordsource: Employees

  6. Add a LastName text box and a FirstName text box to the form.
  7. Add a combo box to the form, and then set the following properties for the combo box:

    Name: Combo2
    Row Source Type: Table/Query
    Row Source: testordqry
    Column Count: 2
    Column Widths: 1";1"
    Bound Column: 1

  8. Add a command button to the form, and then set the OnClick property of the command button to the following event procedure: 
    Me!Combo2.Requery
  9. Save the form as TestParamForm.
  10. Run the TestParamForm form.
  11. Click the combo box. Note that it prompts you to enter an employeeID (as the query did). Enter any number. Then, click OK.
  12. Click the command button. Note that you are again prompted to enter an employeeID. Click the Cancel button. If you receive a Microsoft Visual Basic run-time error, click the End button.
  13. Click the Close button on the form. Note that you receive an error message similar to one of the error messages mentioned in the "Symptoms" section.
Modification Type:MajorLast Reviewed:11/25/2002
Keywords:kbbug kberrmsg KB248904
©2002 Microsoft Corporation. All rights reserved.