MS Access Query (Filter by using keyword)

[malchijah]

I have created an unbound form that I am using to filter records for another form. Everything works great. BUT, I cannot figure out a way to search by keyword. Can I filter a query by keyword using an unbound control?

For example, my form name is INVENTORY and the unbound control name is ITEM. It is controlled by the query INVENTORY_QUERY. I have the criteria field for ITEM in the INVENTORY_QUERY set to LIKE FORMS![INVENTORY]![ITEM] & "*".
I need the query to be able to search for a keyword located anywhere within the field. I do not want to use the FIND box from the menu, but want to create my own text box that can do this. Is this possible?

Thanks,
Malchijah