Dropdown list in a query

[asherbear]

I have a parameter query with the [ ] where the user types in a name. I have tried to set up a drop down list for the user to choose from. But I can't seem to be able to set up the list.



I have a table I can reference that has the data to choose from but can't figure out how to grab it. Do I need some SQL? (not my specialty) or am I missing something?? Any help is appreciated.

Asher

[ConneXionLost]

As you have seen, a parameter query brings up a "dialog box" (a small built-in form) to receive input from the user. The Dialog Box provides only the most basic of functionality for it's intended purpose. If you want more functionality, like the use of a combo-box / drop-down list, then the best approach is to build a form that does the job of the dialog box (and more).

[asherbear]

So I should create a form using the table that has the 10 or 11 choices. Then reference that form in the query? Is that the best way of stating it??

Asher

[ConneXionLost]

Almost.

You need to create a form (unbound is fine), and put a combo box on the form. The combo box needs to show the list of choices. You can do that by building a simple query for the combo box to use (preferred) or you can just link the table to the combo box (this is okay if the table is a lookup table).

Once the form is ready, you need to have your parameter query reference the combo box on the form. You should do this in place of asking for the parameter [] on the query criteria line. You can use the Expression Builder for this if you're unsure of the syntax.

Now that the query is ready, you can go back to your form and add a button to run the query.

Cheers,

[asherbear]

Almost there. I have created a form with a combo box which shows the dropdown choices. Do I put something like this in the query

[forms]![formname]![formfield]

. When I do this it does not seem to work.

Asher

[ConneXionLost]

Something like this:

[Forms]![frmChoice]![Combo0]

In this case, the name of my form is "frmChoice", and the name of the combo box is "Combo0".

Note ~ Once you've added this criteria in the query, the form must be open for the query to run. In other words, open the form, make a selection with the combo box, then go to the query (while the form is still open) and run the query.

Cheers,

[asherbear]

It should work but I have a data mismatch. My problem. Has to do with how I initially set up my queries. (I mistakenly used the lookup function and it's referencing a number and not text. I'll have to fix that. Anyway.

Thanks for the help. thanks for your patience. I'll mark it as solved.......