I have a simple Product Table:
PRODUCT(PROD_ID,Prod_Name,........)
I have a text box on a form, which a sub-form linked to the Product table on it. I'd like to type a word(s) into the text box to search for the product.
How can I do this?

How about a command button that uses the find record function?

they are very easy to use.

Use the command button wizard then select (record navigation)/(find record). I believe that it searches by what ever field is on focus but that may be changeable.