How to Filter Data using a Search Box?

[mesairv]

Hi everyone.

Im new here. I had been reading several topics in line with filtering, but i cannot find one related to my concern.

Please help me to create a command button that will filter my form using a Search Box.

I mean, the value that will be inputted in the Search Box will be used as the criteria to filter the form that i am dealing.

Thank you..

[Seth Schrock]

Is the Search Box on the same form that you want filtered or does the button open another form based on the Search Box?

Overall, the general principle is to create a query with the fields that you want shown in the form and the query has a criteria pointing to the search box. This is extremely simple if you are opening another form, but definitely doable either way.

[mesairv]

The search box is on the same form...

[Seth Schrock]

You need to make your current form based on a query and then turn it into a subform and put the Seach box on the main form. The the query will have the Search Box as the criteria for the field that you are searching. Then all you have to do is in the After Update event of the Search box, add the following code:

Me.{Your subform name here}.Requery

[NeoPa]

Try out some of what you find in Example Filtering on a Form.