Solved

drop down list for query

Posted on 2008-10-05
2
1,800 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 192 total points
ID: 22647368
0
 
LVL 84
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Access Database 5 48
Database maintenance 36 113
Item not found in this collection 5 35
MS Access Combobox to Disable Controls on a Separate Form 10 28
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

696 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