Dynamically open form based on separate saved queries

[tagteam]

Is there a way to open the same form but with different underlying queries?



I have two buttons on different forms that I want to use to open a form with data that matches a certain ID. However, the query that is saved with the form name so while it works for button 1 when i try to open it with button 2 , on the other form, the form name for the query criteria is different and of course it doesn't find the ID.

Is there any way to say something like

If opened with button 1 Then use query 1, if opened with button 2 user query 2?

[pbaldy]

An alternative to using different queries with criteria:

http://www.baldyweb.com/wherecondition.htm

[June7]

This is why I don't use dynamic parameterized query. I prefer to use WHERE CONDITION argument of OpenForm.

And now I see Paul has provided a link explaining that.