**Pass parameters to Report**

[John M]

Hi All,

I have a form that allows the user to select various criteria for report. With this I will set the recordsource for the report.

My question is:
Can I pass some parameters to a report because I have some field's calculation that rely on this?

 

[David R]

If I understand your question correctly, yes, you can refer to those Parameters directly within the report. Are these fields on your unbound form? Use something like Forms![FormName]!FormField to refer to them when your report is running, and make sure you don't close the form until the report has been run.

Post back if I missed the point or you need further clarification.

 

[John M]

You absolutely right David R. I've used the technique before but somehow had forgotten it. Problem solve - thanks for the help.