Creating a drop-down box in a Access query

[qsligh]

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...

SELECT tblITSkillInfo.SkillID, tblITSkillInfo.[Skills/EquipID], tblITSkillInfo.EmployeeID, tblITSkillInfo.YrsExpr, tblITSkillInfo.MnthExpr
FROM tblITSkillInfo
WHERE (((tblITSkillInfo.[Skills/EquipID])=[Skill/Equipment ID]) AND ((tblITSkillInfo.YrsExpr)=[Years Experience]));

QSligh

[MMcCarthy]

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.

[qsligh]

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

[MMcCarthy]

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.