Solved

using a combo box for query criteria

Posted on 2008-10-10
2
1,063 Views
Last Modified: 2012-06-21
Hi Everyone,
I know that by adding this code "[text]" in the criteria field of a query you get a text box to enter the data. My question is can this be a combo or list box of known items.  Also if known, is ther a way to make that text box a two part box for entering a range of choice?

I'm not intermediate for this BTW, i'm a rookie to databases :D
0
Comment
Question by:StanT
2 Comments
 
LVL 10

Accepted Solution

by:
TOPIO earned 500 total points
ID: 22690639

No, other than a text box you can't create controls at run time in a simple query.

For what do you want to do you need to create a form with a little bit of logic behind in order  to do what you want.
0
 
LVL 4

Author Comment

by:StanT
ID: 22701588
I had figured as much. Would be a nice addition to access in the future (if microsoft is listening...lol).  Thanks for your answer. :D
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

770 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