command button that calls a text filter

[QCMan]

I have a form that I input data in. on this form I want a command button that will act just as if I right click on a field and apply a text filter that equals "my input". Yes it is easy to right click and scroll down to "text Filter" then enter but I want to eliminate the right click portion of this step, as I am constantly trying to find something in this field. I have tried several VBA commands and the built in macros but they aren't cooperating with me. Been to several sites and looked over many forums but none have prevailed. The table is not indexed, as it was a basic import from and excel spreadsheet and at the time I didn't want it indexed. In the future it will be.

 

[alansidman]

Here is a tutorial. Advise if you need additional help.

https://msdn.microsoft.com/en-us/library/office/ff197651.aspx

 

[bobsan42]

What is the source of the form - a table ?
Where is the text to be applied as filter - in a textbox?

What I would do is - use a QUERY (instead of a table ) which includes all necessary table fields. As a criteria for the field to be filtered - use something like: LIKE Nz([form].[textbox1],"*"). Since the query will include only one table - the recordset will be updatable.
(may need some digging to make the LIKE to work - in my case it is ALIKE "%")
Then for the textbox in a code for AfterUpdate event include Me.Requery
When the textbox is empty it should show all records, otherwise - filtered.