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

• Microsoft Access 2000

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 this to be a problem in the Microsoft products 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.

Additional query words: pra

Keywords : kbdta
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug