Results 1 to 3 of 3
  1. #1
    crimedog is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Dec 2013
    Posts
    141

    Query on ID if the form is Open

    I need to Query RepID if Form REPID is open - if it is not Open I need to Query EMPID


    REPID and EMPID are numbers

    In Query Builder
    Under REPID iif([forms]![Form1]![TxtRepID]>0,[forms]![Form1]![TxtRepID],"")
    Under EMPID iif([forms]![Form1]![TxtRepID] ??,[forms]![Form1]![TxtRepID],"")

    so if there is a value in [forms]![Form1]![TxtRepID] Query for the REPID
    if there is no TxtREPID (because the form is not open Query for EMPID

  2. #2
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    1,142
    How are you opening/calling this query?

  3. #3
    crimedog is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Dec 2013
    Posts
    141
    found a work around

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

Similar Threads

  1. Replies: 4
    Last Post: 10-09-2014, 07:09 PM
  2. Replies: 1
    Last Post: 03-02-2014, 01:31 PM
  3. Replies: 2
    Last Post: 08-07-2013, 07:44 AM
  4. Help on report to open form to open query...
    By saseymour in forum Programming
    Replies: 13
    Last Post: 07-16-2013, 08:11 AM
  5. Replies: 1
    Last Post: 05-03-2012, 02:25 PM

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