How to determine which tab is currently selected? 2

[CGSB]

I would like to know how I can determine the currently selected tab so that I can call different functions based on the tab the user is on.

Please help.

 

[Eupher]

Hi, CGSB,

The .Value property of the tab control is equal to the index of the currently selected tab page (starting from zero). So, for example, the following snippet of code behind a command button will reveal the currently selected tab page:

Dim iMyInt As Integer
Dim strMyString As String

iMyInt = Me!TabCtl0.Value

strMyString = Me!TabCtl0.Pages(iMyInt).Caption

MsgBox strMyString & " is the currently selected tab page."

HTH,

Ken S.

 

[CGSB]

That's it! Thank you!

 

[TheAceMan1]

How are ya CGSB . . .

1st . . . in parallel with [blue]Eupher[/blue] . . . the [blue]Value[/blue] property is implicit/implied for most controls. So that:

[blue]   intVariable = Me!TabCtlName.[purple][b]Value[/b][/purple]
is the same as:
   intVariable = Me!TabCtlName[/blue]

As the programmer this should suffice for what tab your on. But if you want to ping on the actual text in the tab, you'd perform the following:

[blue]   strVariable = Me!tabCtlName.Pages(Me!tabCtlName).Name[/blue]

I hope you see the jist of it all! . . .

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .