list to choose options in query

  • Thread starter Thread starter carlee
  • Start date Start date
C

carlee

Hi there,

I have a report that, when a button is clicked on a form,
the report runs. This report has several parameter
prompts, asking users for information to run the report.

Is it possible to have a lookup list where the user can
select the criteria from a list, rather than having to
type it in the parameter box, and then have the report run
based on teh info the user selects?

Kind regards,
Carlee
 
carlee said:
I have a report that, when a button is clicked on a form,
the report runs. This report has several parameter
prompts, asking users for information to run the report.
Click to expand...

You should create a form where the user can specify the
query's parameters. Include a button so the users can
indicate that they are done entering the parameters and the
report shold be run. It's easy to modify the query to use
the form controls instead of using those popup prompts.
Just change the parameters to refer to the form controls
instead. E.g. instead of a parameter like [Start Date],
use: Forms!theformname.txtStartDate
where txtStartDate is the name of the text box where the
user can enter a date.

Is it possible to have a lookup list where the user can
select the criteria from a list, rather than having to
type it in the parameter box, and then have the report run
based on teh info the user selects?
Click to expand...

Well, yes it's possible, but there is no built-in feature
for this, so you would have to code up the mechanism
youself.
 
Carlee said:
The next question:

Where could i go to find examples of how this is done?
Click to expand...

Don't know, but where ever they are would highly dependent
on specific details of what/how you want to specify/use the
criteria.
--
Marsh
MVP [MS Access]

-----Original Message-----
carlee said:
I have a report that, when a button is clicked on a form,
the report runs. This report has several parameter
prompts, asking users for information to run the report.
Click to expand...

You should create a form where the user can specify the
query's parameters. Include a button so the users can
indicate that they are done entering the parameters and the
report shold be run. It's easy to modify the query to use
the form controls instead of using those popup prompts.
Just change the parameters to refer to the form controls
instead. E.g. instead of a parameter like [Start Date],
use: Forms!theformname.txtStartDate
where txtStartDate is the name of the text box where the
user can enter a date.

Is it possible to have a lookup list where the user can
select the criteria from a list, rather than having to
type it in the parameter box, and then have the report run
based on teh info the user selects?
Click to expand...

Well, yes it's possible, but there is no built-in feature
for this, so you would have to code up the mechanism
youself.
Click to expand...
Click to expand...
 
Back
Top