Using Dropdown in from to change query criteria

[huntersoasis]

I currently have a dropdown in place on from to change criteria of the query Everything is working fine and in the query it shows

[Forms]![PRODUCTS_FORM]![category_select]

everything works great except this field is not all that the select is... I need something to find any matches in field like

Like "*[category_select]*"

but anyway i try it it does not work.

any suggesting to get the dropdown to put in the query the Like "* and *"

Thanks,

 

[huntersoasis]

none of these work

Like "*[COLOR=#333333][Forms]![PRODUCTS_FORM]![category_select]*"[/COLOR]

Like "* & [COLOR=#333333][Forms]![PRODUCTS_FORM]![category_select] & *"[/COLOR]

I have even gone as far to make a table with the option and included

Like "*Accessories*"

from the original option of just

Accessories

And still no luck

 

[huntersoasis]

SOLVED

Like "*"+([Forms]![PRODUCTS_FORM]![category_select])+"*"

 

[Micron]

I would have recommended this: Like "*" & [Forms]![PRODUCTS_FORM].[category_select]) & "*" as I don't believe in using arithmetic operators on text.
Note that I replaced the second ! also. I guess you have more in the sql that comes after because you say it works yet you have no semi-colon at the end.