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:
When you click Details (on Microsoft Windows Millennium Edition, press ALT+D), you receive the following message:
NOTE: The actual memory address may vary.
If you are running Microsoft Windows NT:
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
- 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.
Additional query words: pra ipf gpf
Keywords: kberrmsg kbbug kbpending KB248904