If Statement in Form problem

:think: 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)

Trial and Error!

I figured it out! Thanks anyway!