ACC2000: Combo Box Wizard Doesn't Work with Third Option When Form Is Based on SQL Statement

When you use the Combo Box Wizard to create a combo box on a form that is not based on any table or query, you see all three of the normal options. However, the following option does not work: If you choose this option, you receive the following error message when you click Next on the second page of the wizard:

The form that contains the combo box must be based on a table or query before the Combo Box Wizard can work correctly when you choose the third option.

To make the third option work correctly when you use the Combo Box Wizard, create a query based on your SQL statement and use that query as the RecordSource property of the form.

Steps to Reproduce Behavior

1. Open the sample database Northwind.mdb.
2. Create a form not based on any table or query and type the following for the RecordSource property:
   SELECT * FROM Employees;
3. Enable the Control Wizards button in the toolbox, and then add a combo box to the form.
4. When the Combo Box Wizard starts, click the third option, Find a record on my form based on the value I selected in my combo box. Click Next.
5. Move the EmployeeID field from the Available Fields list to the Selected Fields list. Click Next. Note that you receive an error message similar to the one mentioned in the "Symptoms" section of the article.

For additional information about the Combo Box Wizard, click the article number below to view the article in the Microsoft Knowledge Base: