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

View products that this article applies to.

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.

Back to the top

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 (http://support.microsoft.com/kb/245025/EN-US/ ) OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)

Back to the top

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.

Back to the top

MORE INFORMATION

Steps to Reproduce Behavior

Open the sample database Northwind.mdb.
Create a parameterized query. From the Orders table, include the OrderID, OrderDate, and EmployeeID fields.
For the EmployeeID field, click to clear the Show check box, and then add the following criteria:
[Enter EmployeeID]
Save the query as testordqry, and then run it. Type any number when you are prompted to enter an employeeID.
Create a new form, and then set the following properties for the form:
Form name: TestParamForm
Form caption: TestParamForm
Recordsource: Employees
Add a LastName text box and a FirstName text box to the form.
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
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
Save the form as TestParamForm.
Run the TestParamForm form.
Click the combo box. Note that it prompts you to enter an employeeID (as the query did). Enter any number. Then, click OK.
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.
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.