Findfirst syntax problem

[tarenja]

I can successfully loop through a recordset and display each record using the code: Debug.Print rsC![activityid], rsC![Timeslot], rsC![Activity]
What I can't figure out is the syntax for findfirst
I want to loop through each item in the recordset rsC and compare rsC![activityid], with another recordset, rsB, that also has an ID field rsB![activityid]
Can anyone help me with the systax for the findfirst part please (I'm fine with the looping part, I just can't get the findfirst syntax correct).

[orange]

You may find this sample useful.
http://msdn.microsoft.com/en-us/libr...ice.14%29.aspx

[tarenja]

Thanks for your help.
My problem turned out to be I was testing for a value that was in the second column of the recordset.
It seems you can't do it.
When I changed the sql statement to bring in the field that I was testing for first the problem went away.
If it's of any value to anyone this is the syntax I ended up using:
If Not rsB.NoMatch Then
rsC.FindFirst "ActivityID = " & Arrayids(i)
Works fine now.