Control subform data from buttons in the container form RRS feed

  • Question

  • I'm using a subform to create a standard interface for all the forms in the system.  So, the header and all the footer buttons are in the container form and then the record data for all the different tables is in the subform. 

    Let's say there are 10 records in a table and we're viewing record 1 in a subform named SubForm.  There's a Form named MyForm with a NEXT button in it. 

    When I click the NEXT button, I'd like the data displayed in SubForm to move to record 2.

    Any idea how to accomplish that in VBA?

    Note: hopefully, I can use the same technique outside of SubForm for New, Save, Undo, Print, etc.

    • Edited by Geek2020 Monday, December 5, 2016 12:04 AM
    Monday, December 5, 2016 12:02 AM