Change Tab Without changing focus
in [Forms]
|
Prev: How do I show Microsoft Access Print Dialog
Next: How to make Access 2007 Navigation pane invisible?
From: Doctor on 5 Dec 2009 22:15 Is is possible to change the active tab of a tab control without using ..setfocus? Based on what Machine a users selects in a combo box, I want to change the current tab to reflect the proper machine. This code is called from several different text boxes in their afterupdate event. But when I tab out, it sets the focus to the tab instead of to the next control. I want to change the tab, but then set focus to the next control. Thanks in advance.
From: Ken Snell on 6 Dec 2009 07:53 Change the Value of the tab control to the desired tab page's pageindex value: Me.TabControl.Value = 3 -- Ken Snell http://www.accessmvp.com/KDSnell/ "Doctor" <Doctor(a)discussions.microsoft.com> wrote in message news:AF16B0D5-815F-45B1-8722-B443EF431F4F(a)microsoft.com... > Is is possible to change the active tab of a tab control without using > .setfocus? > > Based on what Machine a users selects in a combo box, I want to change the > current tab to reflect the proper machine. > > This code is called from several different text boxes in their afterupdate > event. But when I tab out, it sets the focus to the tab instead of to the > next control. I want to change the tab, but then set focus to the next > control. > > Thanks in advance.
From: Linq Adams via AccessMonster.com on 6 Dec 2009 19:01
"But when I tab out, it sets the focus to the tab instead of to the next control. I want to change the tab, but then set focus to the next control." You don't really need to change the tabbed page, per se, simply set focus to the first control on the next tabbed page. If, for instance, you're on Page1 and on Page2 you have a textbox named PageTwoControl use this code PageTwoControl.SetFocus Access will automatically move to Page2 and set focus in the tetxbox named PageTwoControl -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200912/1 |