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

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

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:

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

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.