ADO Find

Hi

I am wanting to use the ADO find command.

To search for records based on one criteria seems easy enough:

myRS.Find ("Field1 = 'xxxxx'")

But how do you put criteria in for multiple fields

i.e. field1 = 'xxxxxxx' and field2 > 111111 etc.

Thanks in advance

Uset the recordset's filter method, which allows for multiple conditions.

Lethal is right

You cannot use the ADO Find method with multiple fields criteria.

So use the filter property

Hi,

I met the same problem b4, and I've investigate the Seek method, and suprise that SQL 6.5 and 7.0 both don't support Seek even u have proper index created.

I would like to know whether SQL 2000 support it or not?

Thx