By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,072 Members | 1,168 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,072 IT Pros & Developers. It's quick & easy.

Creating a drop-down box in a Access query

P: 2
Hello,

I am working with Access 2003 and have the following issue:

I have created some queries that will search my employee’s certification database. I search the database base on type certification and number of year’s experience. I place the ID# in one message box and a number representing the years in another parameter box. This will return any employees that match the given criteria. With over 100 various certifications in my company, it is very hard to remember the ID number for the certification. What I want to do is select the actual certification from a drop down to populate the first box and input the year box as usual. I am having a hard time figuring out just how to accomplish this task. Is there anyone out there who knows if this is even possible? I need to select the "Skills/EquipmentID" from a drop down. This is the SQL code that I've used thus far...

Expand|Select|Wrap|Line Numbers
  1. SELECT tblITSkillInfo.SkillID, tblITSkillInfo.[Skills/EquipID], tblITSkillInfo.EmployeeID, tblITSkillInfo.YrsExpr, tblITSkillInfo.MnthExpr
  2. FROM tblITSkillInfo
  3. WHERE (((tblITSkillInfo.[Skills/EquipID])=[Skill/Equipment ID]) AND ((tblITSkillInfo.YrsExpr)=[Years Experience]));

QSligh
Feb 6 '08 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
It's not clear from your question exactly what you are trying to do. For the moment all I can suggest is you check out this tutorial on cascading combo boxes and see if it helps.
Feb 6 '08 #2

P: 2
It's not clear from your question exactly what you are trying to do. For the moment all I can suggest is you check out this tutorial on cascading combo boxes and see if it helps.
Sorry for the confusion in my opening question. The desired effect is to open a query and instead of having to input the data each time, have the choice of choosing predefined entries from a "drop-down" box. After which I click OK and the query runs.

R,
QSligh
Feb 8 '08 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
You mean you want to set the query criteria to controls on the form?

i.e.

If you had a dropdown box called cboName on a form called frmMain then you could set the criteria as ...

[Forms]![frmMain]![cboName]

The form would have to be open when the query ran.
Feb 8 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.