Passing Parameters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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).
 
Hi Jeff,

Thanks for your help, it worked a treat.

Cheers,
Jen

Jeff Boyce said:
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>

Jen said:
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
Click to expand...
Click to expand...
 
Back
Top