using combo box with query

[oohmygod831]

i am using a parameter query that produces a pivot chart and the user must enter a value (use name) before the chart is produced.

My problem is that the user must know exactly how to spell the name for the query to work.

So i was wondering is it possible to have a form with a combo box and the user pick that name they require from the combo box and that selection would be the parameter used by the query to produce the pivot chart.

 

[boblarson]

Most certainly. Go into the query in design view (in the QBE grid) and in the criteria you would have:

[Forms]![YourFormNameHere]![YourComboBoxNameHere]