Filters of Flters

[paulmcdonnell]

Hi guys...

I can't quite get my filters of filters correct i have a query which filters a table to the first level , I then want to use a form filter to the next filter option which all works ok. But when I want to use my second filter I'm not sure how to use the code to tell access to apply the filter to the previous filter which displayed the data and not the original query..
in summary..

1 My record source query works fine
2 then using a form filter to reduce the number of data works fine.
3 But using an additional filter filters the record source and not reslts from stage 2


Can anyone help, this is a toughy for me.

Cheers
Paul

 

[Alexandre]

I see two possibilities:
-you build on your form filter to combine the where-like filter string with your new criteria string, using
(OldCriteriaString) AND (NewCriteriaString)
-you add an intermediate step: 1.5, by filtering your query (last parameter of DoCmd.OpenQuery, I believe)

Alex