Parameters

A

Alex

Is there a way to have a "look up" for a parameter in a report? The
parameter is set in a query by [ ], which will prompt the user to enter say
an account number before running the report. I would like the user to be
able to select from a list of account numbers instead of having to type the
account number. Is there a way of doing this?
 
T

Terry

Alex,

Rather than a parameter query (with [enter number here])
use a form with a drop down box and reference the drop
down control on your form in your query.

Hope this makes sense and helps,

Terry
 
A

Alex

Terry,

How do I reference the drop down control on a form from a query? In the
query I am not able to select information from a form-only tables or queries?

Alex

Terry said:
Alex,

Rather than a parameter query (with [enter number here])
use a form with a drop down box and reference the drop
down control on your form in your query.

Hope this makes sense and helps,

Terry
-----Original Message-----
Is there a way to have a "look up" for a parameter in a report? The
parameter is set in a query by [ ], which will prompt the user to enter say
an account number before running the report. I would like the user to be
able to select from a list of account numbers instead of having to type the
account number. Is there a way of doing this?
.
Click to expand...
Click to expand...
 
Top