I have some code that opens a form and moves to a specific field on a subform. I want my code to search the listed records on that field, change the value if they are a specific value and loop until the last record. Any record that is changed also needs to have a date entered (in a already assigned variable)
Here is some code to clarify:
If strchoice = vbYes Then
DoCmd.GoToControl "Rank History"
DoCmd.GoToControl "Rank Status"
Do Until IsNull([Rank Status])
-->Here's where I need help
If [Rank Status] = "A" Then
[Rank Status] = "U"
[Date Removed] = datevar
DoCmd.Run Command acCmdRecordsGoToNext
As you can see I would like the value of A to be changed to U and loop until all A's are changed
Thanks in advance