Microsoft KB Archive/219273

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

Article ID: 219273

Article Last Modified on 12/12/2002

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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



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.



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



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



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



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.

