Every time I look for ways to set a parameter from a form everything I see says to instead set the query itself to directly access the form field.
I do NOT want to have to do this. :banghead:
I have multiple reports running off the same query and launched from different forms. I want to be able to determine the key field for the query from the form and then launch the required report. As it stands, I have generated 3 nearly identical queries which I now have to keep in step and where the ONLY difference is the source name for matching the key field to one or other form field.
Thanks guys.
I do NOT want to have to do this. :banghead:
I have multiple reports running off the same query and launched from different forms. I want to be able to determine the key field for the query from the form and then launch the required report. As it stands, I have generated 3 nearly identical queries which I now have to keep in step and where the ONLY difference is the source name for matching the key field to one or other form field.
Thanks guys.