36Rock
12-04-2011, 02:19 PM
: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)
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)