I found this one myself. The ADO find only supports 1 field,
you have to use filter, which seems like overkill, but is how
MS recommends how to do it. This was fixed in ADO 2.5, which
is suppose to be release with Win2K in Feb 2k.

>Hello,
> I am a VFP Programmer and have worked in 5.0 and 6.0
>Now I am doing project in Vb 6.0 In that I want to findout
>a particular record by using recordset.find function.
>It works with one field perfectly.
>But, problem arises that i want to find out a record by
>checking a track of two or it can be more than two fields
>also. At this time recordset.find gives an error like
>"Recordset conflict or Two long data type" etc . . .
>So, how can I find out a particular record by checking a
>track on more than one fields.
>Again, i am using an ADO technology and i am giving a
>command like following.
>
>recordset.find "fieldname=" & "'" & & "'" _
> & " + fieldname=" & "'" & & "'"
>
>
>Thanx in advance
>Amol