Passing Parameters

[Jen]

Hi,

I have a bit of a problem trying to pass parameters to my report.

Basically, I have a standard form which accepts a number of values and also
calls a report. The report is populated from a query. The query prompts the
user to enter 3 values. What I want to do is to pass the values from the form
and use them as input values and not have the user be prompted to enter
anything.

I am sure there is a straight forward work around for this but I cant seem
to find it at the moment, so any help/tips would be appreciated.

Thanks,
Jen

P.S. I am using Access 2003

 

[Jeff Boyce]

Jen

One way to do this is to modify the query so the parameters are provided by
the form. Instead of using something like:

[Enter Your First Value]

as the criterion in your query, refer to the value on the form with
something like:

Forms!YourFormName!YourControlName

Then just leave your report based on the query, and continue to launch it
from your form (you may decide to do some validation in the button click,
before launch).

 

[Jen]

Hi Jeff,

Thanks for your help, it worked a treat.

Cheers,
Jen

Jen

One way to do this is to modify the query so the parameters are provided by
the form. Instead of using something like:

[Enter Your First Value]

as the criterion in your query, refer to the value on the form with
something like:

Forms!YourFormName!YourControlName

Then just leave your report based on the query, and continue to launch it
from your form (you may decide to do some validation in the button click,
before launch).
--
Good luck

Jeff Boyce
<Access MVP>

Hi,

I have a bit of a problem trying to pass parameters to my report.

Basically, I have a standard form which accepts a number of values and also
calls a report. The report is populated from a query. The query prompts the
user to enter 3 values. What I want to do is to pass the values from the form
and use them as input values and not have the user be prompted to enter
anything.

I am sure there is a straight forward work around for this but I cant seem
to find it at the moment, so any help/tips would be appreciated.

Thanks,
Jen

P.S. I am using Access 2003