Results 1 to 2 of 2
  1. #1
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496

    Condition if there is a tempvar

    I'm working with tempvars and I want to have a form open only if a particular tempvar exists.

    however I have to know what action to take if there is no tempvar

    if access can't find a temp var it will give #error in a dlookup

    I would like it to take an action on the condition that the tempvar doesn't exist



    how would I go about this?

  2. #2
    Ruegen's Avatar
    Ruegen is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Location
    Australia
    Posts
    1,496
    Nevermind I had the tempvar name wrong in the vba and the code is working now

    cheers.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Report and IF Condition
    By ismailkhannasar in forum Queries
    Replies: 1
    Last Post: 01-31-2013, 04:29 AM
  2. Join on condition
    By dr4ke in forum Queries
    Replies: 3
    Last Post: 01-28-2013, 10:02 AM
  3. Help with using the AND condition
    By ssturges in forum Access
    Replies: 1
    Last Post: 11-25-2012, 12:36 AM
  4. SDS 3 condition if statement
    By anonix in forum Access
    Replies: 1
    Last Post: 09-07-2012, 12:24 PM
  5. How to use IIF condition
    By nshaikh in forum Queries
    Replies: 4
    Last Post: 09-12-2008, 01:23 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums