Minor problem regarding adding All to a combo box

[JohanJ]

I have a minor problem that makes me frustrated!
I have managed to add All to a combo box when using fields from a table as rowsource. However, I want to use fields from a query instead and this causes an error:

Too few parameters. Expected 3.

Any help on this issue is welcomed!

 

[RV]

I suspect you're using a Parameter Query.
That's explains the "error" (actually, is isn't an error...).

See to it you don't use any parameters.

RV

 

[JohanJ]

I think it's better that I explain what I want to do from the beginning. I'm constructing a database of suppliers and the fisrt option for the user is to select which supplier in a combo box to be illustrated. After that the user should get the oppurtunity to choose between displaying a specific market or all markets where this supplier act on. To perform this I think that I have to use a parameter query, but I'm not an expert so any help welcomed.

Thanks in advance!

 

[ColinEssex]

It looks like you're using a second ComboBox based on the selection of the first.....

look up "Cascading ComboBoxes" in fhe forum help, there's some demo's you can download.

The "adding All to ComboBox" is covered in the Solutions Db that you should have loaded on your PC.

Col