Page visible when check box marked

[Krzysiek]

Hello,
I would like to page on the form with is fileds be visable when checkbox on
the formis marked. How to code the check box?
regards,

 

[Mackster66]

If I understand your question correctly, you want certain fields on your form
to be visible when a checkbox is checked. Try this code in the form's On
Load event:

If Me.CHECKBOX = True Then
Me.FIELD1.Visible = True
Me.FIELD2.Visible = True
Else
Me.FIELD1.Visible = False
Me.FIELD2.Visible = False
End If

You will need to change CHECKBOX to the name of your checkbox and FIELD1 to
the name of the field you want to make visible, etc. Add on as many fields
as you need.

If you want to have the fields actively change visibility based on a
checkbox on the form then add this same code to the checkbox's After Update
event.

 

[Krzysiek]

Hello,
I was not precise enough. I was asking how to make one of the pages from Tab
Control visible when check box is marked. Please advice.

 

[PieterLinden via AccessMonster.com]

Hello,
I was not precise enough. I was asking how to make one of the pages from Tab
Control visible when check box is marked. Please advice.

If I understand your question correctly, you want certain fields on your form
to be visible when a checkbox is checked. Try this code in the form's On

[quoted text clipped - 20 lines]

Me.pgMyPage.Visible = (Me.Check5 = Checked)