move through records in a datasheet subform 1

[stkarma]

What is the correct way to move through records in a datasheet subform to set the value of a field? (use setfocus & gotorecord OR do loop method OR ?). Please give sample code. Thanks!

 

[tcurtis]

MoveFirst, MoveLast, MoveNext, or MovePrevious method.
Check these out and see if they help you out....look in your help for these methods.

 

[stkarma]

I setfocus to subform & used gotorecord last record then loop to previous record. Once it reaches the first record, there is no previous record. So I have on error, exit sub.

In order to use movenext, movefirst, etc I have to reference a recordset. The form is already designed to bring in matching records into a datasheet subform.

Wondering if there is a better way than gotorecord command I used above.

Thanks!