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