Drop-down list n parameter query

[mleiser]

My users find it hard to use my parameter queries because they have to enter exact spelling. If the field that has the parameter value is driven by a list or table, is there a way to provide a drop-down with the values for the user to choose from?

 

[boblarson]

Use a combo box on a form for input. You can then refer to the form (keep the form open) when you open the queries. The criteria in the queries would be something like

[Forms]![YourFormNameHere]![YourComboBoxNameHere]

 

[cgemmill1]

Bob, I tried what you suggested and this did not work. I have included in a report header the dropdown box. When I run the report I still get the parameter box from the Query. In the query I referenced the dropdown box. Can you assist me?

 

[boblarson]

Bob, I tried what you suggested and this did not work. I have included in a report header the dropdown box. When I run the report I still get the parameter box from the Query. In the query I referenced the dropdown box. Can you assist me?

Post the SQL for the query (with your reference that you stated you tried using). To get the SQL of the query, open the query in design view and then go up to VIEW and select SQL View. Copy the contents and paste it in here.

 

[cgemmill1]

Here is mh SQl code SELECT tbl_CDS.[Organization Name], tbl_CDS.Project, tbl_CDS.Measure, tbl_CDS.[Data Collected], tbl_CDS.Numerator, tbl_CDS.Denominator, tbl_CDS.[Measure Rate], tbl_CDS.Timeframe, tbl_CDS.[Start Date], tbl_CDS.[End Date]
FROM tbl_CDS
GROUP BY tbl_CDS.[Organization Name], tbl_CDS.Project, tbl_CDS.Measure, tbl_CDS.[Data Collected], tbl_CDS.Numerator, tbl_CDS.Denominator, tbl_CDS.[Measure Rate], tbl_CDS.Timeframe, tbl_CDS.[Start Date], tbl_CDS.[End Date]
HAVING (((tbl_CDS.[Organization Name])=[Reports]![rpt_CDS_Hospital]![Combo28]))
ORDER BY tbl_CDS.[Organization Name], tbl_CDS.Project;