Tab Control Event

[Paul H]

This is a simple one I hope. I have a tab control (tabctl10) on a form with 7 pages. Depending on the page selected I want to display certain controls like txtFromDate and txtToDate. I have tried both the on Change event and the On Click event for the Page. The On Change event runs every time I click a different tab, which is what I want, but I want to write and If Then statement or a Case statement to run different code depending on the page selected. I can't seem to track down this property. This is what I am working with. It doesn't work, but you get the idea.

Private Sub TabCtl0_Change()
        
        If Me.TabCtl0.Control.Name = "Page57" Then
        MsgBox "hello"
            Me.txtFrom.Visible = True
            Me.txtTill.Visible = True
        Else
            Me.txtFrom.Visible = False
            Me.txtTill.Visible = False
        End If
        
End Sub

[June7]

Google: Access tab control page has focus
See if this helps http://www.fmsinc.com/MicrosoftAcces...abs/index.html

[Paul H]

Thank you, thank you, thank you.

Nice to hear from you again.

Paul

[Micron]

if that doesn't work for you, here's one way to reference the page via it's caption.
MsgBox Me.TabCtl28.Pages(Me.TabCtl28.Value).Caption
Don't think I've ever used the control reference to a tab page - prefer to reference the pages collection

[Paul H]

I'm not finished, but it came out like this.

    Select Case Me.TabCtl0.Value
        Case 0
            Me.txtFrom.Visible = False
            Me.txtTill.Visible = False
            
        Case 1
            Me.txtFrom.Visible = True
            Me.txtTill.Visible = True
        Case 2
            Me.txtFrom.Visible = True
            Me.txtTill.Visible = True
        Case 3
            MsgBox Me.TabCtl0.Pages(3).Name
        Case 4
            MsgBox Me.TabCtl0.Pages(4).Name
        Case 5
            MsgBox Me.TabCtl0.Pages(5).Name
        Case 6
            MsgBox Me.TabCtl0.Pages(6).Name
        Case Else
            MsgBox Me.TabCtl0.Value
    End Select

Just what the doctor ordered.

Paul

[HiTechCoach]

You might find this helpful:

Wizard Form template


It will show you how to work with the different pages of a tab control.

[Paul H]

Thanks, Boyd.

[HiTechCoach]

You're welcome. Glad we could assist.