Page visible when check box marked

K

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,
 
M

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.
 
K

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

make field invisable 4
Special view of form for users 1
Applying update on click to all related records 5
Checkbox Next to Mail Message - How Do I Make It Visible? How Do I Make a Check Appear? 1
Check box question 2
Check box question 2
Make text box visible only when check box is True 6
write conflict 2

Top