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

 | 
Pages: 1
Prev: How do I show Microsoft Access Print Dialog
Next: How to make Access 2007 Navigation pane invisible?