P
Patrick
I have 2 queries based on the same table relationships. One of them has an
additional criteria. I would like to be able to display the results of either
query in the same form. I though that this would work..
DoCmd.OpenForm "frmMiscForm" , acNormal, "qryTest1" (filtername refers to
a query)
...but I was wrong.
I also saw something in the forums about specifying the RecordSource =
"qryTest1" in the OpenArg portion of the OpenForm command... but again, I
could not make it work.
The only way I have been able to get what I want is to put the query name in
the Record Source for the Form, itself... but that means I would have to
create a form for each query... basically the exact same form. That seems way
too messy.
Any ideas?
Thanks!
patrick
additional criteria. I would like to be able to display the results of either
query in the same form. I though that this would work..
DoCmd.OpenForm "frmMiscForm" , acNormal, "qryTest1" (filtername refers to
a query)
...but I was wrong.
I also saw something in the forums about specifying the RecordSource =
"qryTest1" in the OpenArg portion of the OpenForm command... but again, I
could not make it work.
The only way I have been able to get what I want is to put the query name in
the Record Source for the Form, itself... but that means I would have to
create a form for each query... basically the exact same form. That seems way
too messy.
Any ideas?
Thanks!
patrick