Option Group

[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

 

[Keith Wilby]

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

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

 

[Marshall Barton]

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.

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.

 

[Chi]

Thank you so much Keith,

I got it. It works very well!!