How do I display additional hidden choices when a selection is made?

[dap6c6]

I am creating a form for users to submit computer acess. I have several choices for them to choose, however depending on the choice there are hidden options that I want to have display for them to choose from too. In the property sheet I have those lables hidden so that they don't display on the main form. How to I get them to display when a primary choice is made?

[patjones]

This is something that you need to use a little bit of VBA code for. What kind of control are you using for the choices? (e.g. option group, combo box, etc.)

Pat

[dap6c6]

Thanks..I am using a check box control.

[patjones]

OK, speaking generally, suppose you have a check box called chk and a label called lbl. In the On Click event for the check box, this code will achieve what you're looking for:

Private Sub chk_Click()
 
Me.lbl.Visible = Me.chk
 
End Sub

The Visible property for a label can be either TRUE or FALSE, and the check box status of checked or unchecked corresponds to these boolean values respectively.

Pat

[dap6c6]

I'm sorry but that didn't work for me...

[patjones]

Can you post the code that you used?

[dap6c6]

Private Sub Check48_Click()
 
Me.Check73.Visible = Me.Check48
Me.Lable74.Visible = Me.Check48
 
End Sub

[NeoPa]

I would suggest the AfterUpdate event might be a more reliable one to use. Otherwise I have no idea what the question is about. I'm assuming Pat does. If not, remember it's easier to deal with questions that don't make sense by reporting them for clear-up.

[patjones]

Is your control name really "Lable74" or is it "Label74"? Also make sure that you compiled and saved the code prior to returning to the form and trying it.

You can also try AfterUpdate as NeoPa suggests; however, I did test this in my sandbox database and found that it works. So I'm not sure off the top of my head what else could be the issue.

[patjones]

Did we resolve the first issue for you? If so I would suggest a new thread for this question as it is not related to the original topic. Thanks.

[dap6c6]

Yes, thank you I had a typo...