Can you be a little more specific? Not sure I understand your goal.

I have a combo box with that is used as a lookup for our historical society's museum assessions db. The lookup table has 3 fields, [CategoryID], [Category] and [ConsistOf]. The ConsistOf field has examples of what types of items the [Catagory] represents. Because there is a paper listing of categories that has been produced of many years the result is somewhat of a mess. Because the  people that will use this form in the future I would like to make the combo box search all three fields as they type no matter what field the text may reside. I tried concatenating all three fields in the combo box query as the search field in the combo box but can only get it to search in the beginning of the field and not anywhere within the new field.  I do not want the user to open another form to do this if it can be prvented. Is this a possibility?

Can you show me some example data?

Just off the top of my head, it sounds like these lessons may help you: Search As You Type examples in both Access Developer 8 and the Search Seminar.

And yes, you're probably going to have to concatenate your Category and ConsistOf fields together and perform a Search as you Type against that field. Multiple LIKE statements too.