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


The information in this article applies to:

  • Microsoft Access 2000
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.

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.

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.
Modification Type:MajorLast Reviewed:12/12/2002
Keywords:kbbug kbdta KB219273
©2002 Microsoft Corporation. All rights reserved.