Courtesy of Richard's Fitness 52 video, the VBA code below toggles a check box, everything works fine excepting the first record.

Default value for the individual records check box is TRUE.

FIRST press of the button - changes FIRST record check box to FALSE, ALL OTHER records remain TRUE
SECOND press of the button - changes FIRST record check box to TRUE, ALL OTHER records change to FALSE
THIRD press of the button - changes FIRST record check box to FALSE, ALL OTHER records change to TRUE

And so on, alternating between the SECOND and THIRD presses, the FIRST record is marching out of tune with the rest of the records.

Does anyone have any idea what is happening? I would be quite happy to use a wraparound solution, treating the FIRST record differently to the other records but I don't seem to be able to use rs.FindFirst correctly.

Private Sub Command23_Click()
Dim rs As Recordset
Set rs = CurrentDb.OpenRecordset(SQL)
Do While Not rs.EOF
If rs!YN = YN Then
    rs.Edit
    rs!YN = Not rs!YN
    rs.Update
Else
    Exit Do
End If
rs.MoveNext
Loop
rs.Close
Set rs = Nothing
Me.Requery
End Sub