how to disable a tab control page based on value in other field

[pdtit]

Hi there,

I have a form on which I have a tab control with 2 pages; one is used for main data, the other one for detailed data.

If on my form a checkbox "detailed" is not selected, I want the "detailed" Page be disabled as well.


Regards,

Peter

 

[DrSimon]

This should work:

Private Sub Detailed_AfterUpdate()
If Me.Detailed = True Then
    Me.Page2.Visible = False
Else
    Me.Page2.Visible = True
End If
End Sub

You'll need to decide which you want as the default: with or without detail

Simon Rouse

 

[pdtit]

Thank you very much for this fast answer !!

It works great,

Regards,

Peter