For Each

[David W]

How would you loop through the field [washed] in each record using the
single form mode, not continious?

 

[Ken Snell [MVP]]

The choice of view for the form is not important for how you do this. It's
done the same way:

With Me.RecordsetClone
.MoveFirst
Do While .EOF = False
Debug.Print .Fields("washed").Value
.MoveNext
Loop
End With