setting criteria in a memo field

[cntrintern]

I have a query that filters if a record is "Multi-cultural"
then if it is I run it through a second query that will search an [Additional information] Memo field based a one word value the user enters. I know how to set in the criteria Like "*word*" and it will search anywhere in the memo field for that word.
I know that [Forms]![frmName]![Field] using the form the user entered the value on.
I can't seem to put the two together. Can someone help me?

Thank you.

-cassie

 

[tlbroadbent]

Place the following in the query criteria for the field, [Additional information].

Like "*" & [Forms]![frmName]![Field] & "*" Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it if you have time.

 

[cntrintern]

That is so simple and it works perfectly!!
Thank you so much!!

-cassie