Consulting

Results 1 to 2 of 2

Thread: If Statement in Form problem

  1. #1
    VBAX Newbie
    Joined
    Dec 2011
    Location
    Texas
    Posts
    2
    Location

    Question 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)

  2. #2
    VBAX Newbie
    Joined
    Dec 2011
    Location
    Texas
    Posts
    2
    Location
    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
  •