Capture Active Page Name of a TabControl

[jmgibson]

Is there a way to capture the Active Tab Name on a Tab Control. My VB is rusty, but I want to do something like.

varActiveTabName = me.TabControlName.Name

Ultimately, I want to use the variable in a query so that when a Tab is Clicked, the query will re-run based on the new tab name.

Select * from tblClasses where Category = varActiveTabName

Any Thoughts?

 

[MajP]

the value of the tabctl is the index of the selected page. So

Private Sub TabCtl0_Change()
dim activeTabName as string
activeTabName = Me.TabCtl0.Pages(Me.TabCtl0.Value).Name
End Sub