drop down box for a Parameter in Query

[MikeD]

I have a report in Access that is based on a query with a parameter in it
(for customer name). Is there a way to have a drop down box list the
customer names in the parameter instead of me having to make sure I spell it
correctly.

I want to go to a report...open and it ask me which customer and give me a
drop down box so I can pick. Is this possible? If not any other
suggestions?

 

[Duane Hookom]

IMHO, parameter queries are never good user interface. Check out
http://www.tek-tips.com/faqs.cfm?fid=6763. Always use controls on forms for
user entry.

 

[MikeD]

Duane,

You are the man. Thanks

IMHO, parameter queries are never good user interface. Check out
http://www.tek-tips.com/faqs.cfm?fid=6763. Always use controls on forms for
user entry.