A recordset find with multiple criteria.

[qwert231]

I want to do a find with something like this:
"OrderID LIKE '" & orderID & "' AND SubjectID LIKE '" & recSet("SubjectID&quot & "'"

That line of code following my recSet.Find gives me an error:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

This error usually means I haven't set the Const for the adBatchOpenOptomistic or whatever, but I have, and this command works in other code... just not with multiple criteria. Any ideas?

 

[playerham]

Whenever I use a recordset field, I usually say rsTest.fields("field_name&quot instead of rsTest("field_name&quot. See if this helps.

 

[qwert231]

That's extra code, the default value is .Fields, so you can save yourself a lot of time doing it like I do. And that doesn't matter on a .Find.