Enabling textbox & dropdown upon check

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello. While I have experience with other types of code, I have never coded
in VBA. I'm assuming that since this would be relatively easy to perform in
other code, it will be here, but feel free to tell me if this is a bridge too
far for a beginner.

I have a textbox and combo disabled in my form. I would like to enable them
if and when a particular checkbox is checked. How would I do this?

Thanks in advance.
-K
 
I have read some of the posts here that may apply and amended my question ...
I actually have a textbox and subform I want to activate. I have tried the
following code:

Private Sub extension_AfterUpdate()
Me.num_yrs_prev_funded.Enabled = (Me.extension.Value = Yes)
Me.IRAD_targeted_programs_subform.Enabled = (Me.extension.Value = Yes)
End Sub

Where extension is the checkbox; num_yrs_prev_funded is a textbox; and the
last one is a subform.
I get reversed behavior - UNCHECKING the box enables the other two. I have
tried changing the right side values to No, and have gotten the same result.
Any insight?

Thanks
Keith
 
Changed the above values from Yes to True and I got the behavior I needed.

Thanks for your time.

Keith
 
Back
Top