drop down list for query

Hi,

I have parameter queries with reports attached. Instead of typing the required data in, how do I set up a drop down box or combo box to choose the option that I want please?

regards, portlandnow
portlandnowAsked:
Who is Participating?
 
libin_vCommented:
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
IMO you should avoid parameter queries. Instead, but a query without parameters and run your reports either (a) from an existing form, where you'd navigate to the record you want to show and then click a Print button or (b) from a "report builder" form where you'd select various criteria and such to correctly build/filter your report. Using this type of strategy, you could then have combos, listboxes, etc to use as selections.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.