>>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.
>>Also, I am using an ADO technology and I am giving a
>>command like following and I have created an Indexes also on
>>those fields which I want to search.
>>
>>recordset.find "fieldname=" & "'" & & "'" _
>> & " + fieldname=" & "'" & & "'"
>>
>>I know it is not possible but is there any other method to
>>find out the records so that I can proceed further.
>>
>>Thanx in Advance,
>>Amol
>
>Sorry Amol, but it's not possible. The Find method only supports single criteria searches. If you want to search by multiple criteria you'll have to do another query.

Look at the way I am doing the find in the message to Dave Harris, thats another way. The practicality of that way will have to be up to you.

HTH