The ADO find method only accept one column name at a time.
Enmanuel
>When I use the following an error show like this:
>
>oRS = oCon.Execute("SELECT * FROM Employee")
>oRS.Find("LastName Like 'Jun%' And FirstName Like 'Lop%' And MiddleName Like 'Roq%'")
>
>Error message show:
>
> OLE IDispatch exception code 0 from ADODB.Recordset:
> Arguments are of the wrong type, are out of acceptable
> range, or are in conflict with one another...
I'm a mixture of Albert Einstein and Arnold Schwarzenegger. The only trouble is that I got Einstein's body and Schwarzenegger's brain