Tab only visible when field = x

[ecpike]

Is it possible to make a tab on a form only visible when the user enters specified information into a field? For instance if the field "EventType" = Fall, then the tab named "Fall" would appear.

Thanks, Eric

[RuralGuy]

Each TabPage has a Visible property. Does that help?

[ecpike]

No, the visible property is only yes/no, if set to no, it can't be seen at all. I want it to show up under certain circumstances as in the OP...

[RuralGuy]

No, the visible property is only yes/no, if set to no, it can't be seen at all. I want it to show up under certain circumstances as in the OP...

What you say is true. You will need to perhaps use the Current event of the form to check your conditions and set the Visible property of the page accordingly.

[ecpike]

OK I got it... I used this thread for ideas: https://www.accessforums.net/forms/h...form-2081.html

Here was the code that I came up with:

Private Sub Combo22_AfterUpdate()
If [EventType] = "Fall" Then
        Me.Page6.Visible = True
        
    Else
    
        Me.Page6.Visible = False
        
    End If
End Sub

[RuralGuy]

You are also going to want to put something in the Current event of the form. Something like:
Me.Page6.Visible = ([EventType] = "Fall")

[ecpike]

Thanks for your help!

[RuralGuy]

Any time. Glad I could help. Is it time to mark this thread Solved?