Results 1 to 3 of 3
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Form with 2 subforms (Access XP)

    I have a Main form with 2 subforms.
    I select a record in the main form, this then displays records in the 1st subform and the 2nd subform. After entering data in the 2nd subform is there a way to go back to the first subform and move to the next record in that subform. I can set the focus on the 1st subform from the 2nd subform but I don't know how to move to the next record of the 1st subform.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Form with 2 subforms (Access XP)

    Once you have set focus to the first subform, you should be able to use

    RunCommand acCmdRecordsGoToNext

    or

    DoCmd.GoToRecord , , acNext

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Form with 2 subforms (Access XP)

    Thank you Hans

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •