My IF statement works great but it doesn't update the Units field in my form.

If Me.Units.Value > 2 Then
Me.Units.Value = 2
End IF

I watch the values in the code and see that the Units value does change to 2 whenever the value is greater than 2. But for some reason the acutal field in the form and table doesn't change/update.

I know it's probably something simple but I don't see it. Can anyone point me in a direction?

Thank you, Deb (36Rock)