I am having trouble working out how to specify 2 fields values in the FIND method for ADODB recordsets.

I have tried various versions of the following:

criteria1 = "[field1] = 'value1' AND [field2] = 'value2'"
rst.Find criteria1, , adSearchForward

it works when i use one of the fields eg:

criteria2 = "[field1] = 'value1'"
rst.Find criteria2, , adSearchForward

i guess there is some other format for achieving this. I have faint recollections of seeing something like Array(field1,field2) ... somewhere but then again it might just have been a dream.