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]