Hi [vb6; DAO; MSAccess]

I need to filter a recordset then filter it again. does this work by simply
Code:
db_rs.Filter = "(field1 = string1)"
db_rs.Movefirst
string2 = field2
db_rs.Filter = "(field2 = string2)"
so basically the first set is filtered, and a field fromthe first record of the filtered set is used to create a filtered "sub-set" of the originall filter.

should this work or is there a better way to do it?
thanks


just thought maybe it should be:
Code:
db_rs.Filter = "(field1 = string1)"
db_rs.Movefirst
string2 = field2
db_rs.Filter = "((field1 = string1) AND (field2 = string2))"
??