adodb.find method

[nilch]

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 ?

[Lothar Haensler]

MSDN article Q195222 describes 3 workarounds for this problem:
- use Filter property
- use Filter and close
- create a custom find routine

my personal favorite: do all you database access via stored procedures and call the SP with different (find) parameters.