Question on the 'or' property of a query

[lccrews]

I'd like to get a little more clarity on how to use the 'or' property of the query. I have a query set up to return results based on input from a form text box. That same query is also being used on a different form. I'd like to list that 2nd form in the 'or' function, but every time I run the query a parameter (the unopened form) is being displayed. Is it possible to get the query to work with both forms without showing the parameter pop up for the closed form? ...Or do I have to create 2 identical queries?


Example: I have a query to return all records related to "CO#" from Forms!myform1!Mycontrol. I'd like to have Forms!myform2!Mycontrol in the 'or' function. So when I open myform1 and run the query, I do not get a popup asking for input from myform2

[June7]

I don't use dynamic parameterized queries. I prefer VBA to filter the form (macro can do this as well).

So code behind myform2 to open myform1.

DoCmd.OpenForm "myform1", , , "[fieldname]=" & Mycontrol

This allows more flexibility in using the query.

[Micron]

Is it possible to get the query to work with both forms without showing the parameter pop up for the closed form? ...Or do I have to create 2 identical queries?

What I think you're asking for is doable but requires coding. You cannot expect a query to simply default to one of the OR criteria statements simply because it cannot resolve the other one. It's like saying, If I say to you "Do A if balloon is blue or do B if ball is black" and I don't show you the ball, what are you going to say? Show me the ball...

You might be able to call a function that checks to see which form is open and then returns the value from the correct control on the opened form.