Form with Search Box

[chineloogbonna]

Good Afternoon,
I am wondering if someone can assist with a form with a Search box query. I know how to add a query for one key word with a pop up MsgBox but what Im looking for is a form with a textbox that allows the user to input a word or phrase. When the search button is clicked it will run a query that filters a table based on the keyword or phrase.

Any help would be greatly appreciated!

Thank you.
Chinelo Ogbonna

 

[JHB]

There is an example here:
http://allenbrowne.com/ser-62.html

 

[NauticalGent]

The easiest way would be in the Criteria of your query grid, put

Forms(“YourForm”).[YourTextBox]

This method is frowned upon by serious developers (which I am NOT), but it is the easiest and requires no code. A word of caution, your form MUST be open or the query will throw an error and not execute.

 

[NauticalGent]

I see JHB beat me to it!

 

[jdraw]

Here is a free video by Steve Bishop showing setting up a Keyword Search.