Checkbox automatically checks based on another value

[brett429]

I have a form where two fields (input by the user) are calculated in a text box that will either result in a positive or negative number. If the number calculated is negative, I want a checkbox on the form to automatically "check." Otherwise, it should remain unchecked. How can this be done? THANKS!

 

[edtab]

Try:

If Me.Result = < 0 then
Me.Checkbox -1
Else
Me.Checkbox = 0
End If

Substitute your own textbox names.

 

[brett429]

Try:

If Me.Result = < 0 then
Me.Checkbox -1
Else
Me.Checkbox = 0
End If

Substitute your own textbox names.

That worked, thank you for the help!