Text box entry Populates a checkbox

[JPW]

I have a text box called 'txtvalue' and whenever an amount is entered into that field I would like the tick/check box which is called 'deductable' to be True. Can this be achieved and if so how?

Thank you.

 

[missinglinq]

Private Sub txtValue_AfterUpdate()
  If Not IsNull(Me.txtValue) Then
    Deductible = -1
  Else
    Deductible = 0
End If
End Sub

If Deductible is a bound control (is tied to a field in the underlying table) this is all you need. If it's an unbound control, you'll need to repeat this code in the Form_Current event.