• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1097
  • 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
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

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

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