D David Nov 28, 2003 #1 In VBA I want to open a tabbed form at a given tab, not necessarily the first tab. How do I do that?
M Mark Phillipson Nov 28, 2003 #2 Hi, Try: Me.tabControlName.Pages("pgePageName").SetFocus HTH -- Cheers Mark Free Access/Office Add-Ins at: http://mphillipson.users.btopenworld.com/
Hi, Try: Me.tabControlName.Pages("pgePageName").SetFocus HTH -- Cheers Mark Free Access/Office Add-Ins at: http://mphillipson.users.btopenworld.com/
J Jim Allensworth Nov 28, 2003 #3 In VBA I want to open a tabbed form at a given tab, not necessarily the first tab. How do I do that? Click to expand... There is a Pages collection of a tab control. You just set the focus to that page. The collection is zero based so to set the focus to the second tab use: Me.tabMyTab.Pages(1).SetFocus You could place this in the form's Open event or just after the command to open the form. - Jim
In VBA I want to open a tabbed form at a given tab, not necessarily the first tab. How do I do that? Click to expand... There is a Pages collection of a tab control. You just set the focus to that page. The collection is zero based so to set the focus to the second tab use: Me.tabMyTab.Pages(1).SetFocus You could place this in the form's Open event or just after the command to open the form. - Jim
