Knowledge Base

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

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

  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.

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


Additional query words: doesn t doesn t does not cannot

Keywords: kbprb kbusage KB198947


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.