Option Group

  • Thread starter Thread starter Chi
  • Start date Start date
C

Chi

Hi,

I create an option group that has A, B, C and Other radio buttons. What I
would like to do is that when the users select the Orther button, the textbox
named INPUT visible for them to enter their comments.

Please help.

Thank you,
Chi
 
Chi said:
Hi,

I create an option group that has A, B, C and Other radio buttons. What I
would like to do is that when the users select the Orther button, the
textbox
named INPUT visible for them to enter their comments.

Please help.

Thank you,
Chi
Click to expand...

Something like this in the OG's After Update event:

If Me.ogrMyOptionGroup = n Then
Me.txtComments.Visible = True
Else
Me.txtComments.Visible = False
End If

where "n" is the value of the "Orther" radio button.

Keith.
www.keithwilby.co.uk
 
Chi said:
I create an option group that has A, B, C and Other radio buttons. What I
would like to do is that when the users select the Orther button, the textbox
named INPUT visible for them to enter their comments.
Click to expand...


Add a line of VBA code to the option group's AfterUpdate
event procedure:
Me.INPUT.Visible = (Me.optiongroup = <other option no.>
Add the same line of code to the form's Current event
procedure.
 
Back
Top