HELP - Use the LIKE (*) to find a word anywhere in the field.

[Radar]

I have two drop down boxes for the user to search for a product
one is by Reorder# and the other by NameOfItem.
I am thinking about using an underlying query To prompt the user for a
word . Like ([Type a Word]) & ("*")
This works, but how do you get it to search the word any where in the
field.
May be there is another way or sample of how to do this

Thanks
Radar

 

[John Spencer]

I think what you want is

LIKE "*" & [Type a word] & "*"

 

[Radar]

Thanks for the quick response
That is what I wanted

Radar