Ques. on a report's Input Parameter in its property box

[batteam]

I have db with multiple forms. Three of these forms let the user run the same report (bound to the same stored proceddure)from a command button on each form. My question is: is there any way to alter the Input Parameter statement in the report's property box to accept a parameter from more than just one form? An example of my Input Parameter on my report is:

@recordid = Forms!frmSales_MainData![txtHideRecordID]

This code, of course, only lets the report run when the user is in the form "frmSales_MainData. I now see my only alternatives are making copies of the same report (one for each form) or having the report only run from a special "Reports Generation" form. But is there a way to give one report the same parameter from more than one form? Thanks in advance for any help you can offer.

 

[ronspree]

How about a global variable that is assigned by the calling form. Then, let the report retrieve this global variable and place it the input parameters of the report.

 

[cjowsey]

I do something similar, but I use functions to set and get the parameter rather than a global variable.