Report using drop down msg box with combo list

[ShouldBeFishen]

I have a queary that prompts for a name then delivers a report showing data against the name I have chosen.

The report calls on a query with the following prompt that is in a msg box.
[Enter area name here]

What i would like is the message box with a combo list of the area names in it to choose from as the user does not always know what area names are available.

Help on this matter would be appreciated.

Thanks.

 

[dhookom]

Don't use parameter prompts. Consider the better solution as described at

http://www.fontstuff.com/access/acctut08.htm.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]