Visibility of other controls

[jlclark4]

Sometimes you want to control the visibility (or other property) of one control to be based on the value in another.



I have "Option 42" which is a Y/N selection.
I also have "Label 48" which I want to become active only if Option 42 is Yes.

What is the best thing to do in this situation? Any suggestions?

J

[weekend00]

in the option42's event:
private sub Option42_click()
label48.visible=option42
end sub

[jlclark4]

I cant get it to work, even played with the numbers some. Let me know sure It's still the same.

"Complaint?" = Label 40
"No" = Option42
"Yes" = Option 44

"Compliance" = Label 48
Drop Down of types = Type of Complaint

So to get the Compliance/Type of Complaint to become active when the Yes button is clicked
In option44's event:
private sub Option44_click()
label48.visible=Option44
end sub

Is that correct? If so, maybe I am misunderstanding where the placement should be. (see attached jpeg)

[weekend00]

are option42 and option44 in a option group box so that only one of them can be selected?
in this case, the option44_click event won't trigger when click.
you need to put codes in the frame1_beforeUpdate(), and please set the value of option42 to 0, value of option44=-1

Private Sub Frame17_BeforeUpdate(Cancel As Integer)
label48.visible=frame17
End Sub

[jlclark4]

Yes. They are in "Frame39". I will try what you just sent me.

[jlclark4]

Okay, That worked. Now is it possible by doing the same thing, to have the drop down that goes with the Label48 to appear only when Yes is selected as well?

[weekend00]

do forget to set the value of option42 to 0, value of option44=-1

[jlclark4]

I figured it out. I changed Label48 to TypeOfComplaint within the code you sent me. Thank you so much for your help weekend00!