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