Solved Navigation tabs left side and top side controls

[donkey9972]

I do appreciate all the help that I get on these forums. However, you are right, I have not used navigation forms before, and I am sure there are numerous issues that I have not seen that will arise. I have opted to use half and half. Half built in navigation form and half custom. Basically I have an old DB I am converting over to be used again. However it has some different requirements, but the data is essentially going to be the same. So it will basically work like this. On the left side you click one of the built vertical in navigation buttons. Then once that button is pressed it will display tabs across the top specifically in the category for the button to the left. For instance the top left button will have 6 subforms associated with it. The 2nd tab on the left side once clicked will open up and have 8 subforms associated with it, etc.... I just wanted to try something different. So far it is working okay. If at some point this does not work how I am wanting it to, I always have an option to scrap the idea of the navigation forms and go with what I already know.

I hope that gives a little context to what I am doing. But this does lead me to a 2nd question. What is needed when a navigation form opens to start it on the 2nd verticale tab on the left side, which in my case that tab is called 'NavigationButton9" currently.

 

[AngelSpeaks]

How are you coding your top half? Sounds like a good solution to me.

 

[donkey9972]

There essentially is no code. I have created an original form off of my table, in this case called frmCoversheet. Then I created an additional form with all the tabs going across it horizontally, in this case called frmInputForms. Then I add frmCoversheet to frmInput as a subform. Then I added frmInput as a subform to frmNavigation. Then I simply adjust the layout how I want. I am certain I might run into some problems as Pat suggested I would once I start making subsequent forms (subforms). But for right now it works really nice for what I am trying to do. I just need to get the form to open on the 2nd tab, on the vertical tabs because I am not using the first tab. I don't like its positioning.

I have attached the parts of the DB I am currently messing around with. But on the form that opens I want it to open on the Input Forms, and that is where I am currently stuck at.

 

[donkey9972]

Okay, then since there doesn't seem to be a lot of information on how to do what I was wanting to do I am going to say this is an unsolveable issue.

 

[Pat Hartman]

Is this better? I just resized the list control to drag the top down.

 

[Edgar_]

I just need to get the form to open on the 2nd tab, on the vertical tabs because I am not using the first tab. I don't like its positioning.

There’s no need to hide or disable the first button or get the form to open on the second tab.
Tweak the first button's top padding to get the appearance you want (as shown in the sample file of post #14)

If you still want to get the form to open on the "second tab", which is "frmInputForms", just add this to "frmNavigation":

Private Sub Form_Load()
    DoCmd.BrowseTo acBrowseToForm, "frmInputForms", "frmNavigation.NavigationSubform"
End Sub

Okay, then since there doesn't seem to be a lot of information on how to do what I was wanting to do I am going to say this is an unsolveable issue.

You might have had better luck inspecting the file that I made for you a few days ago.