ADODB find

Hi Experts

Using two adodb recordsets I want to find a record in rst1 that is equivalent to a record in recordset2. How would I achieve this.

rst1.find(rst2.fields(ID).value = & rst1.fields(ID).value)

The values are integers

Regards
Joe
LVL 1
JoeBo747Asked:
Who is Participating?
 
DhaestCommented:
I guess something like this:

rst1.find("ID = " & rst1.fields("ID").value)
0
 
JoeBo747Author Commented:
Hi Dhaest

Thanks for your reply. Thats exactly what I needed>

Regards
Joe
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.