Tab control: How do I navigate from to a subform to another subform

[smsmail]

Hello,

I have a tab control, the first page of the tab control is a menu, all other pages of the tab control are bound subforms.
From within a tab/subform, I want to be able to navigate to another tab/subform of a tab control in the onclick event of a button on the subform.

I have tried setting the tab control's value property to the specified page I want to navigate to (i.e. TabCtl0 = 4), but it does not work.

What am I doing wrong?

Thanks in advance for your help!

 

[PWise]

try

Me.Tab.Value = [i]index of page that you want[/i]

 

[TheAceMan1]

How are ya smsmail . . .

PWise code would work if focus were on the mainform, however you've just hit a button on one of the subforms ... so focus resides there.

Try the following ([blue]you[/blue] substitute proper names in [purple]purple[/purple]):

[blue] Dim frm As Form
 
 [green]'Set mainForm Object
 '(Me.CommandButtonName.Parent.Parent.Name) is MainForm Name![/green]
 Set frm = Forms(Me.[purple][b]CommandButtonName[/b][/purple].Parent.Parent.Name)
 
 [green]'Goto page of subform[/green]
 frm![purple][b]TabControlName[/b][/purple].Pages("[purple][b]PageName[/b][/purple]").SetFocus
 
 [green]'Set focus to specific control[/green]
 frm![purple][b]OthersubFormName[/b][/purple].Form.[purple][b]ControlName[/b][/purple].SetFocus
 
 Set frm = Nothing[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]