How to move to next record

[srast]

Hello all.
I have a form with a subform. The subform coantains several records, and the view (for the subform) is Single Form.
I have a button on the main form that performs certain functions when clicked, and then I want it to move to the next record of the subform.
Anyone have an idea of what code I could use? Is there a method or function available? (Will Movenext work here?)
Thanks.
Steve

 

[annsolomon]

Try this:

DoCmd.GoToRecord , [your subform name here], acNext

 

[srast]

Someone suggested the Bookmark property. I made a clone of the recordset, and set the clone's Boookmark equal to form's Bookmark. Then, move the clone one record forward with MoveNext. Finally, set the form's Bookmark equal to the clone's Bookmark. That way, whatever record the user scrolls to via the navigation buttons, the button moves one record forward.
Hope this helps someone!
Thanks.
Steve