table traversal

[tuyo]

Hi!
i need help in my code. i need to use the field values in one table and check if the same values are in the other table.

table 1 table 2
a charles a
b george a
c junior c

so far i have

With table
Do Until .EOF
.MoveLast
.MoveFirst
For Each fld In .Fields
If fld.Name = "branch" Then
Call Searchtable2
End If
Next
Loop
End With
Exit Sub

my problem is, table 1 doesnt move to the next row. it only goes through it once. help pls!
Thanks

[jzwp11]

I believe you need a .movenext

With table
Do Until .EOF
.MoveLast
.MoveFirst
For Each fld In .Fields
If fld.Name = "branch" Then
Call Searchtable2
End If
Next
.MoveNext
Loop
End With
Exit Sub