Tom O: Gave me this code from earlier today. However I still need some help on this. The code that he gave me works great but it does not clear the optionbuttons until the user clicks ok so they never see it. I need them to see it. So how do I make this happen on the "fly" If the checkbox is false then the optionbuttons should be false, null not checked. This of course is all in a userform. TIA and thanks again To

With Me.checkboxJ
If Me.checkboxJL.value = True The
strJL = "JL
Me.Frame1.OptionButton1.Enabled = Tru
Me.Frame1.OptionButton2.Enabled = Tru
Els

Me.Frame1.OptionButton1.Value = Fals
Me.Frame1.OptionButton2.Value = Fals
Me.Frame1.OptionButton1.Enabled = Fals
Me.Frame1.OptionButton2.Enabled = Fals
End I
End Wit

--
Regards
Tom Ogilv


I have checkboxJL if it is on it has a value of JL. I then have
optionbuttons that are used also. If the checkbox is flase I want to mak
sure that the user cannot click and turn on either one of the optionbuttons
the optionsbuttons are within a frame. Currently right now the user coul
turn on one of the option buttons weather the checkbox is true or false. Ho
do you code to make this happen? TI
With Me.checkboxJ
If Me.checkboxJL.value = True The
strJL = "JL
Els
Me.checkboxJL = Fals
End I
End Wit
If obReqJL = True Then strJLtype = Require
If obOptJL = True Then strJLtype = Optiona