Improve company productivity with a Business Account.Sign Up

x
?
Solved

drop down list for query

Posted on 2008-10-05
2
Medium Priority
?
1,821 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 86
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
With the functions here, you can parse, convert, and format back and forth between feet and inches and fractions and decimal inches - for normal as well as extreme values and with extreme precision.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

595 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