• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1090
  • Last Modified:

using a combo box for query criteria

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
StanT
Asked:
StanT
1 Solution
 
TOPIOCommented:

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
 
StanTAuthor Commented:
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now