Ignore Query criteria when pulling for 2 forms

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]

Answer 1

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...