How can I use a text value from an open Form in a criteria expression in a new query?

[John Lissenburg]

I thought this would be simple, but not if you want to use a 'Like' expression to filter for a specific Keyword (from a Combo Box in an open Form) in my [Keywords] field of my new Query (unrelated tables). (I'm a relative novice - not very familiar with code - I usually use the Query Design window). I'm stumped. Any help would be appreciated

[June7]

Not much info there.

Maybe this is what you are trying to do: http://www.datapigtechnologies.com/f...tomfilter.html

[John Lissenburg]

Thank you! The video link was very useful (I learned a few things!) It gave me the clues I needed to come up with the expression: Like ("*" & [Forms]![ReportControler]![Text14] & "*") - which solved my problem. Thanks again!