How to determine which tab was clicked 1

[colezpapa3]

I have a tabbed form...there are 5 tabs that the user can select. Is there a way to determine which tab was clicked.
I know there is a pageindex property...but it is not visible in intellisense.

 

[PWise]

Look @ the OnChange Event

Private Sub TabCtl_Change()
Debug.Print Me.Sforms.Value
End Sub

 

[JBinQLD]

G'day fella,

I seem to recall you can use something like

yourresult=me!tbYourTabControl.pageindex.name

and/or

yourresult=me!tbYourTabControl.pageindex.caption

Hope this helps,

JB

 

[PWise]

pageindex is used to set the pageindex

to get the name or caption when the user clicks use this code

Private Sub TabCtl_Change()
Debug.Print Me.Sforms.Value
Debug.Print  Me.Sforms.Pages(Me.Sforms).Name,
Debug.Print Me.Sforms.Pages(Me.Sforms).Caption
End Sub

 

[JBinQLD]

That's the one Mr Pwise. I remember years ago it took me ages to get the syntax right. The help file is a little misleading on this so hopefully others will scroll past my bum steer to your correct info!

 

[colezpapa3]

got it, thanks all. As usual this site is great.