Ignore Query criteria when pulling for 2 forms RRS feed

  • Question

  • I am looking for help with criteria filters in ACCESS.

    Trying to use the same criteria from 2 different locations (forms) only 1 will be open at a time but it still is looking for the info

    "Enter Parameter Value" box comes up looking for info from the closed form, when I click enter it looks for the second form and the correct info is loaded

    criteria is as follows

    Like *******Form1******[COMP INV LOC] OR LIKE ********FORM2*********[COMP INV LOC]

    Thursday, February 21, 2019 4:44 PM

All replies

  • Hi Clyde. You might consider using TempVars instead. Otherwise, the forms will have to be open for the query to "see" the values (or lack thereof). Just my 2 cents...
    Thursday, February 21, 2019 5:01 PM