<div>
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 &quot;report builder&quot; 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.
</div>


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.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
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?<br />
<br />
regards, portlandnow
</div>
</div>


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

drop down list for query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.