Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    280
    Thanks
    0
    Thanked 0 Times in 0 Posts

    If is Not (Access 2000)

    I have the folloiwng working code :


    If IsNull(Me!Quantity) And Me!cartons = 0 And Me.Parent!Customerid <> 123


    I want to add on the following condition, meaning that it will be valid only when the the button Command580 is not pressed :

    And Is Not Null Me.Parent!Command580 Then

    But my line does not succeeed, and i get an eror. Where is my fault?



    If IsNull(Me!Quantity) And Me!cartons = 0 And Me.Parent!Customerid <> 123 And Is Not Null Me.Parent!Command580 Then

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: If is Not (Access 2000)

    You need to use Not IsNull(...):

    If IsNull(Me!Quantity) And Me!cartons = 0 And Me.Parent!Customerid <> 123 And Not IsNull(Me.Parent!Command580) Then

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •