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

SYMPTOMS

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:

Find a record on my form based on the value I selected in my combo box.

If you choose this option, you receive the following error message when you click Next on the second page of the wizard:

The Microsoft Jet database engine cannot find the input table or query 'SQL Statement'. Make sure it exists and that its name is spelled correctly.

CAUSE

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.

RESOLUTION

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.

MORE INFORMATION

Steps to Reproduce Behavior

Open the sample database Northwind.mdb.
Create a form not based on any table or query and type the following for the RecordSource property:
SELECT * FROM Employees;
Enable the Control Wizards button in the toolbox, and then add a combo box to the form.
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.
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.

REFERENCES

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

208807 ACC2000: Combo Box Wizard Does Not Allow Selection of Table/Query