Using combo box for query value

[yawalias]

Hi,



I would like to make a form that has a combo box to select a value from to run a query. I would like to use the selected value in the combo box in a query to find a specific item in the database. I would like the query to run when the run query button is selected. So far I have not had any luck. I have tried setting criteria in the query, but it does not work, etc. I have been reading various articles, but I can't figure out how to get the selected combo value into the query.

Thanks!

[jbarrum]

combo boxes are built on forms, not inside of a query. Combo boxes allow a user to select a valaue from a drop down that will display all data that pertain to that record. Is that what you are trying to do?

[MAF4Fam6]

Try the following in your query's criteria:

Like [Forms]![frmDoSearch]![Combo0]

Replace frmDoSearch with your form's name.
Replace Combo0 with the name of your Combo box, found in your Combo Box's property sheet...in the Other Tab.

-RC

[jbarrum]

RC,

that is interesting. I did not know that you could do that? Thanks for sharing.

[MAF4Fam6]

No problem.
You can also use wild characters to broaden your search from your Combo Box's value.
Here is an example:

Like "*" & [Forms]![frmDoSearch]![Combo0] & "*"

-RC

[jbarrum]

This is why I like this site. thanks for sharing

[BlueIshDan]

This should generate a form for you to go by
https://www.accessforums.net/code-re...orm-44282.html

[rpeare]

why are you cross posting your thread to everything else on the message board? even when the question has nothing to do with your application?

[BlueIshDan]

I thought that the code within the form could educate yawalias on how to put combo box values into his query.
I also didn't post that thread across all threads on the message board, only on the ones that could use it to help them solve their problems.
I'm sorry if my actions have aggravated you. Just trying to help.