-
If Statement in Form problem
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!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules