How do you use multiple criteria in a "Find" statement? The problem: I have two recordsets open. As I iterate through the first set of records I need to pull records out of the other recordset. Two fields are needed to get the data I need. Any suggestions?

This code just does not want to work:
RS2.Find "site_name = '" & RS("site_name") & "' And use = 'Fax' And city = '" & RS("city") & "'"

Here is the error:
The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.

Thanks a lot,
dave