Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009
    Posts
    67

    Unanswered: Please I need help with Form

    Hi, I have continuous Form that I have two fields that using Dlookup. When I don't enter the look up filed or when I first open the form the fields for the look up are showing (error) but when I enter information is working fine. How do I move the error default. Thanks

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    =IIf(IsNull(LookupField),"",YourCurrentExpression)
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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