I have the below do while loop to identify the value in a table's field. Everything seems to be going well except for some reason my variable always returns the value of the last field in the table. It will loop through the correct number of times for the number of records in the table, but it always returns the same value when I step through the code. Any suggestions?
Code:
Set db = Access.Application.CurrentDb
Set rst = db.OpenRecordset("DenialReason")
With rst
'.MoveLast
.MoveFirst
Do While .EOF = False
varOfferIDCheck = OfferID
'!Rec_Group = AssignGroup(!Rec_Type)
.MoveNext
Loop
End With
I am aware I have ".MoveLast" commented out. I tried it with it not commented out and the same result occured.