Creating a drop down list in a report

[Luke_Murphy]

Hi

Not sure if this is an easy one or a tricky one!...

Does anyone know how to create a drop down list in a report? The report runs from a query and we would like to view the report and select criteria from a drop down list rather than use a parameter query (where users could type in an incorrect name)

Many thanks!

Luke

 

[KenHigg]

Sounds like you need to base your report on a combo box on a form.

kh

 

[maxmangion]

you can use an unbound combo box which you will populate it with the criterias. Then you simply reference the combo box name in your parameter query i.e. [Forms]![FormName]![ComboName]

 

[Luke_Murphy]

Thats great!

Thanks v much for your help guys

Luke

 

[maxmangion]

You're welcome