My code does what I want – but I did see "overflow errors" as I coded.
Is my use of Do While <> Nul ok. Can it be improved.
My Table tTask has fields: Task, Priority
A query sorts my tasks by Priority
I Open a form based on this query and run this code
Code:DoCmd.GoToRecord , , acFirst Do While Me.Task <> Nul If Me.Task = "xx" Then Me.Priority = 999991 End If DoCmd.GoToRecord , , acNext Loop