Tab-Page-Index

[Tracy]

Please can someone tell me how I can check which page is selected on a tab control. I've checked the help, but cannot work it out. Must be a super simple thing.

Thanks
Tracy

 

[Tim K.]

You have to use the OnChange of the tab control to check which page is selected, sthg like this.

Private Sub TabCtl0_Change()

    Select Case Me!TabCtl0.Value 'Returns Page Index
        Case 0 'Page Index for Page 1
            MsgBox "You have selected Page 1"
        Case 1 'Page Index for Page 2
            MsgBox "You have selected Page 2"
    End Select
    
End Sub