Filter by Selection

[Hunter666]

I need to be able to filter by selection using VBA but havnt got a clue.
i need to search a field (no problem)
find the data i want to filter and then filter it.
Can anyone please help???

 

[David R]

I often just reopen the form with a WHERE clause set to the data I want to filter by. As long as the form is already open this process is very quick and painless.

Example: DoCmd.OpenForm "FormName",,,"[City] = '" & Me.CitySearch & "'"

Post back if you need more help.