Running through each recoird

Lanason

Registered User.
Local time
Today, 17:23
Joined
Sep 12, 2003
Messages
258
is there a simple loop that will allow me to run through all records in a form and perform an action on each record, then move on to the next ?

how do I stop at the end ??
 
Simple example;

Code:
With Me.RecordsetClone
    .MoveFirst
    Do While Not .EOF
        'do something
    .MoveNext
    Loop
End With

Edit: forgot the .MoveNext when first posted
 

Users who are viewing this thread

Back
Top Bottom