Is there a quicker way 1

[fileman1]

Is there a faster method to find a record than this?

 Do While Not rs3.EOF
    If rs3!TargetID = PK2 And rs3!ID1 = PK1 Then
        Do something in here 
        Exit Do
        End If 
     rs3.MoveNext
        Loop

Starting to take a while to find

 

[dhookom]

How about providing some context and perhaps more code. You haven't provided much to work with.

Duane
Hook'D on Access
MS Access MVP

 

[PHV]

If DAO and PKs are numeric:

rs3.FindFirst "TargetID=" & PK2 & " AND ID1=" & PK1
If Not rs3.NoMatch Then
  Do stuff here
End If

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[fileman1]

I am looping a recordset in vba to find a record in the recordset that meets with 2 conditions being met

rs3!TargetID = PK2 And rs3!ID1 = PK1

 

[fileman1]

Thanks PHV, thats what I wanted.