Microsoft KB Archive/198947

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

Article ID: 198947

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q198947



Novice: Requires knowledge of the user interface on single-user computers.



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 ' '. 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.



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.</li></ol>

<div class="references_section">