[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

drop down list for query

Posted on 2008-10-05
2
Medium Priority
?
1,813 Views
Last Modified: 2012-06-22
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
0
Comment
Question by:portlandnow
2 Comments
 
LVL 5

Accepted Solution

by:
libin_v earned 576 total points
ID: 22647368
0
 
LVL 85
ID: 22652329
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question