@Pansmanser, this isn’t an answer, but a comment to help clarify what you want to do.
How does what you want to do relate to the already existing filter feature, that to me, appears to do the same thing?
For example, start with this table (you may need to zoom your browser in to see it more clearly):
In it under the Major Category click on ‘Home’ on record with ID of 3 to select it.
Next click on this icon which sets up a filter so that now the only records shown are those with Major Category = Home.
Undo it with
Ok, then by going to Menu | Customization I was able to drill down to this to find the name of the function is
AutoFilter. Now the next step is to figure out how to call it with a macro.
But… I don’t know how to do that. Am searching…
Ok, can’t find how to do that.
So, instead need to be able to get the value of the current field, then put that into an appropriate filter.
Do you know how to do that already? It’s a matter of starting MRI when the field is clicked, then drilling down to find the text in the field, then using that to create the sql to put into the form’s (table’s) filter.
This somewhat depends on what type of control you want to be able to click on. Simple text boxes are fairly easy, pull down boxes (combo or list) are harder.