Database searching and opening in subforms

[neodj]

Basically i have a form which i want a person to be able to input a word into the text box and then click a search button. Which then runs a query to find words that match the word in the text box. I have put in

Like [forms]![form1]![text4]

to make the query search for the keyword but that does not work. Also i want to make the query come up in the subform but i am not sure how to do this. I'm guessing that it is in vba as i have a brief knowledge of it.

Thanks

 

[neodj]

I have managed to make the search work now but i still cannot get the query to open in the subform window

Any ideas?

cheers