Use same query with different forms

[tom24]

Hi, Hope someone can help me.

I have written an Append Query which uses data from a form.
My form name is "BOX", so a parameter in the query would show as
Forms!BOX!Text999 for example.

I now need to perform exactly the same query using a form called "CURTAIN", so this would now read: Forms!CURTAIN!Text999

I know I could just copy the query and rename it (and the parameter) for the new form, but there are a lot of them and I would prefer it if I could pass the form name as a variable to the query, so one query would cater for both forms.

Thanks

 

[wiremonkey22]

Sorry im confused you want one parameter query you would like to have open two forms build on the same query?

 

[tom24]

Sorry if I wasn't clear. The two forms are mutually exclusive, so will not be open at the same time. The query will run from each form separately, so I just need to know how I can reference the form that is being used at the time, within a generic query.

Hope this clarifies.