I have a table for equipment. There can be up to 4 descriptors for the equipment piece (Descriptor 1, Descriptor 2, etc).

On a form, I want the user to be able to search using two unbound text boxes - so if they enter "short bed" - the query should show all records that have "short bed" in any of their descriptors.

The problem arises when I add the second text box. Not sure how to do that -

I have looked up Query by Form at MSN Access Help but that just seems to confuse me since I am not all that familiar with VB - I usually work with the queries, forms, etc directly along with macros.

Any help would be greatly appreciated.