How to determine Page on Tab Control 2

[illini]

I'm looking for a way for my program to determine which Page on a Tab Control is active.

My goal is to click a command button and have the program do different functions depending on which page/tab is active.

 

[3587]

The following should get you what you need. Place this code in the On_Change event of the tab object.

Dim strValue As String
With Me.TabCtl14 ' Replace with the name of your tab control
     strValue = .page(.value).Caption
End With
Select Case strValue
     Case "Tab Page Name Here"
          'Enter your code here.
     Case "Tab Page Name Here"
          'Enter your code here.
     Case Else
End Select

Good Luck