Microsoft KB Archive/248904

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

Article ID: 248904

Article Last Modified on 11/25/2002

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.



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

</li> Add a LastName text box and a FirstName text box to the form.</li> 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

</li>  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 </li> Save the form as TestParamForm.</li> Run the TestParamForm form.</li> Click the combo box. Note that it prompts you to enter an employeeID (as the query did). Enter any number. Then, click OK.</li> 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.</li> 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.</li></ol>

Additional query words: pra ipf gpf

Keywords: kberrmsg kbbug kbpending KB248904

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.