Results 1 to 3 of 3

Thread: Using a Navigation Form as a subform?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2019
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Using a Navigation Form as a subform?

    Hi,
    I am trying to figure out if there is a simple way to use the Navigation Form option as a subform. I have 6 tables and corresponding forms (and 4 look up tables). My top level table/form identifies a person with two tables branched from there, with one of those tables having 3 more associated "child" tables. I created a navigation form with all my child tables but I would like to view the top level table/form no matter what navigation tab I am looking at. Not sure if that makes sense but does anyone know how to achieve that? Thanks in advance

  2. #2
    New Member
    Join Date
    Aug 2019
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Using a Navigation Form as a subform?

    Ok, so since posting I have figured out a little more. Navigation Form doesn't seem to be set up for what I was trying to do. I have set up a form with my parent table at the top and then tabbed subforms beneath so I can switch between different child tables but still see my parent table data.

    Now my new question...

    Similar to the navigation form I would like to have horizontal and vertical tabs. Horizontal tabs are easy and I have incorporated but I'm not sure how to get the vertical tabs to work properly. I read some other posts saying I can use a "trick" to create the appearance of vertical tabs by using option group toggle buttons which I set up. Where I am stuck is the macro or code to use to get the toggle buttons to link to the pages I want on click?

  3. #3
    Board Regular
    Join Date
    Jun 2015
    Location
    Ontario, Canada
    Posts
    1,698
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Using a Navigation Form as a subform?

    I have never tried to replicate vertical tabs, but would think that command buttons would be the way to go. If you used the button option for horizontal tabs, you'd have some consistency in appearance. Regardless, the control you use would need to have code for a click event but I don't know what you want to show. If you have pages in a tab control and they have buttons/tabs across the top, what do you want to reveal with a set of horizontal buttons down one side?

    Anyway, Me.tabcontrolName.pages(1).setfocus where tabcontrolname is the name of your tab control. The page index is zero based.
    Tips for posting problems:
    1) "doesn't work" doesn't help. Post error message text/numbers and/or state what's happening.
    2) if posting code or sql, use code tags; specify on which code line errors occur, if applicable
    3) try to be specific; assume we know nothing about your issue - because we don't!

    Make all suggested changes in copies of your database or to its objects.

    "1 out of 1010 people understand binary. The other 1001 don't."

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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