I have a modal form that I am popping up that lists several accounts in a grid. When you click on one of those accounts, it changes the detail view in the background to display the detail of the selected account.
However, because the modal form is open, you cannot click on the background detail view to change the tab displayed. I would like to do this programmatically so the user could have a drop down tab list on the modal form and when they select from this list the main view tab is changed in the background view.
Is this possible?
1) The first thing I did is populate a combo box via SQL, listing all of the Account Tabs from the Plugins table.
2) Then you can use this code, to change the visible tab...
Application.MainViews.ActiveView.Tabs.ActiveTab = Application.MainViews.ActiveView.Tabs.Item("Account:Details")
Simply replace "Account:Details" with whatever tab form you wish to be selected. You can also get a bit clever with your SQL as well and make sure that the combo is only populated with tab forms that the user has rights to see.