Form Filters Help

[JeffG3209]

I have a form with 485K rows. I would like to be able to filter the form in various (but simple) ways.
I do enjoy DataPig Technologies videos. I watched this one http://www.datapigtechnologies.com/f...earchform.html , but I am a bit confused. I does run the search but instead of filtering the results on the form it filters the results and opens up a query table.

I would like to filter the form results just like right clicking and using the access filter. Any thoughts?

I attached a screen shot to make it simpler to see my goal.

[June7]

In adapting the Datapig demo did you set the filter parameters of the form's RecordSource query? Then the code behind the Run Query will be Me.Requery instead of the OpenQuery.