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