Tab control - Select Specific Tab When Clicking Object

[RXX00]

Hi,

Is it possible to tell access to go to certain tab on a tab control when you click a specific object?

Thanks

RXX00

 

[MarkK]

Yes, you can set the Value property of the tab control to the PageIndex property of the page you want to make current. You can also run the SetFocus method of one of the Pages in the tab control's Pages collection. Consider the following Sub...

Sub SetFocusToNamedPage(PageName As String)
[COLOR="Green"]  'makes the page named 'PageName' current[/COLOR]
  Me.MyTab.Pages(PageName).SetFocus
End Sub