Form with Search Box

chineloogbonna

Registered User.
Local time
Yesterday, 19:16
Joined
Jul 30, 2018
Messages
65
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
 
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.
 

Users who are viewing this thread

Back
Top Bottom