Find Record with ADODC

[KevinD]

I have been using DAO data controls in an application I am writing and upgraded to VB 6.0 so changed to the ADO data control.
The database is Access 2000 and I have queries which are passed a number of arguments from VB.

With DAO I used 'FindFirst' successfully but this is not available with ADO so I tried 'Find' but it will only allow one argument to be passed.
With the ADO data control, how do I now return a record in an Access database via an Access query where more than one argument is passed?

[Forest Dragon]

You cannot use ADO's Find method with multiple conditions. Instead, you can use ADO's Filter method or create a query.

[KevinD]

Thanks mate! I've got it now.