value of option button

[jebushatescats]

Hello all

I have 2 option buttons grouped together on a frame. I need to be able to determine if one or the other is checked to allow a textbox to be either visable or not visable. I am having a heck of a time trying to determine wqhich property changes when an option button is either selected or not selected.


thanks

 

[THWatson]

jebushatescats
By frame I assume you mean an Option Group.

Each of the option buttons in the group will have a value. I assume they will be 1 and 2.

On the AfterUpdate event for the Frame, put the following code...

If Me.YourFrameName = 1 then
Me.YourTextBoxName.Visible = True
Else
Me.YourTextBoxName.Visible = False
End If

Tom

 

[abaldwin]

Or if you get to the point where you have more than two you can use
select case me.yourframename
case = 1
me.yourtextboxname.visible = true
me.othertextboxes.visible = false
case = 2
me.yourtextboxname.visible = true
me.othertextboxes.visible = true
case = 3
etc et etc
end select

Andy Baldwin

"Testing is the most overlooked programming language on the books!