Lanason Registered User. Local time Today, 12:05 Joined Sep 12, 2003 Messages 258 Apr 10, 2012 #1 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 ??
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 ??
B Beetle Duly Registered Boozer Local time Today, 05:05 Joined Apr 30, 2011 Messages 1,807 Apr 10, 2012 #2 Simple example; Code: With Me.RecordsetClone .MoveFirst Do While Not .EOF 'do something .MoveNext Loop End With Edit: forgot the .MoveNext when first posted
Simple example; Code: With Me.RecordsetClone .MoveFirst Do While Not .EOF 'do something .MoveNext Loop End With Edit: forgot the .MoveNext when first posted