when using ADO control , the find method for the data object does not support more than one field criteria.
i.e

sqlwhere = "field1 = '???' and field2 = 'xxx'"
datactr.find sqlwhere

-- returns an error since there are two fields in the criteria statement.

What is the method to get around this limitation of ADO without using the seek method ?