Eenable a Textbox via Chechbox

[soupisgood84]

I am trying to have a check_box enable one or more of my Txt_boxes. I have place the below code in the before_update event. Could anyone help me out and let me know what I did wrong with this. Thanks

If Nz(Me.Check28, True) = True Then
    Me.txtStartDate = Enabled
    Me.txtEndDate = Enabled
    End If

 

[KyleS]

What you've got there looks like it should work (I got it to)

but try this instead:

Private Sub Check28_BeforeUpdate(Cancel As Integer)
    If Me.Check28= True Then
        Me.txtStartDate.Enabled = True
    Else
        Me.txtStartDate.Enabled = False
    End If
        
End Sub

Just to be sure, you put your code in the before_update event of the checkbox, right?

Kyle

 

[soupisgood84]

I see where I went wrong.

Me.txtStartDate.Enabled = True

not

Me.txtStartDate = Enabled

Thank you for your help!

 

[KyleS]

HTH soup!

Kyle