G
Greg
I am trying to compare data in 2 recortsets and if there is no match then
delete the record from rst2. I've got myself confused! Can someone help?
Thankyou.
rst1.MoveFirst
Do Until rst1.EOF
Do Until rst2.EOF
If rst1!ID = rst2!ID Then
Exit Do
End If
rst2.MoveNext
rst1.Delete
Loop
rst1.MoveNext
Loop
rst2.Update
delete the record from rst2. I've got myself confused! Can someone help?
Thankyou.
rst1.MoveFirst
Do Until rst1.EOF
Do Until rst2.EOF
If rst1!ID = rst2!ID Then
Exit Do
End If
rst2.MoveNext
rst1.Delete
Loop
rst1.MoveNext
Loop
rst2.Update