Parameter query based on a combo box

[ppataki]

Dear All,

I have a combo box in a form, would it be possible (and if yes how) that after selecting an item from the list, that item will be used as a parameter in a query?

Many thanks in advance

 

[ajetrumpet]

the parameter syntax in the WHERE clause of the query is:

WHERE [Yourvalue] = forms!YourFormName!ComboBoxName

 

[ppataki]

Thank you!! It works perfectly

 

[ajetrumpet]

no problem.