Filter Form that's already Filtered

[slyvsspy]

Can I set up a command button that will run another filter on a form that is already filtered.

When I do a second filter, it filters all the records instead of just the records that are already filtered.

any ideas??
Josh

 

[Alexandre]

You have to combine your filtering criteria with AND
Ex. Filter applied to your form is "[ID] = 1"
New filter you want to apply to further filter you form: "[FirstName] = 'John'"

You've got to build the filter string: "[ID] = 1 AND [FirstName] = 'John'"
and apply it as a new filter for your form