>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=" & "'" & & "'"

You cannot execute the FIND method with more than one field. This is a serious constraint to this method.

Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com