Query Parameters passed from Forms

[Guest]

I am passing parameters from forms with no problem. I don't like that I must
specify the name of the form in the query parameter. I would like to use the
same query for multiple forms. Is there away to not specify the form name in
the query parameter, so that parameter knows to just use the current/open
form.

Thanks for your help.

 

[Rick Brandt]

I am passing parameters from forms with no problem. I don't like
that I must specify the name of the form in the query parameter. I
would like to use the same query for multiple forms. Is there away to
not specify the form name in the query parameter, so that parameter
knows to just use the current/open form.

Thanks for your help.

You can write a custom function that gets the value from whatever form is open
(what if more than one is open?) and use the custom function in your query.

 

[Guest]

www.joshdev.com has a utility to send multiple parameters from one single
form to any number of reports without tying your query to the form