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

• Microsoft Access 2000

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.

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:

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

Additional query words:

Keywords : kbusage kbdta FmsCmbo FmsCmbob
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb