Can we make this criteria in a query?

[ariansman]

We make a criteria in a query to get data from form1 like: [forms]![form1]![text1]. This requires us to have the Form1 open and there should be a data in Text1.


Can we make the criteria to either take the data from Form1 like the above, or if Form1 is not open it gets data for the criteria from another form like : [forms]![form2]![text2].

[June7]

Not with parameters in query. Need to use code to build filter criteria and apply it to the form when opening. Use the WHERE CONDITION argument of OpenForm method. This can be done in macro or VBA.