ACC2000: "No Value Given..." Error Using Combo/List Box Wizard

View products that this article applies to.

This article was previously published under Q219273

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

This article applies only to a Microsoft Access database (.mdb).

↑ Back to the top

Symptoms

When you use the Combo Box Wizard or List Box Wizard to create a combo box or a list box based on a query, you may receive the following error:

No value given for one or more required parameters.

↑ Back to the top

Cause

You are trying to create a combo box or list box based on a parameter query.

↑ Back to the top

Resolution

To create a combo box or list box based on a parameter query, set the RowSource property of the control manually.

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

↑ Back to the top

More information

Steps to Reproduce Problem

1.	Open the sample database Northwind.mdb.
2.	In the Database window, click Forms under Objects, and then click New.
3.	In the New Form dialog box, click Design View, and then click OK.
4.	Make sure the Control Wizards is enabled in the toolbox. It is enabled when it is pressed in.
5.	In the toolbox, click Combo Box. Draw a combo box on the form.
6.	On the first screen of the Combo Box Wizard, click I want the combo box to look up the values in a table or query, and then click Next.
7.	On the second screen of the Combo Box Wizard, under View, click Queries. In the Which table or query should provide the values for your combo box list, click Employee Sales by Country. Click Next.
8.	Move Country from the Available Fields list to the Selected Fields list. Click Next. Note that you receive the error message listed at the beginning of this article.

↑ Back to the top

References

For more information about the RowSource property, click Microsoft Access Help on the Help menu, type RowSourceType, RowSource properties in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

↑ Back to the top