Onclick event

[tmcrouse]

I have a form and one of the list boxes looks at what is in a table. Such as MS Certified, Excel Certified, etc. It is a skills table in the database. Each skill has a number of questions that have to be completed assigned. Such as Ms Certified will have 5 and Excel Certified will have 7. What I need to do is in the onclick event when they choose from the combobox, whatever they choose displays the number of questions in this textbox below.



so the label is skill: the combobox is skill and it looks at a table in my database.

then the next is:

label is number of questions in this skill set: the textbox is number of questions and that number of questions is in the skills table in its own column. so I have tried the onclick event and different query strings but nothing works. the only thing I can figure is doing case select and saying if the skill = MS Certified then 5 else if Excel Certified 7...etc...but there are 151 of these and that seems like tons of work and there has to be a way onclick for it to look for an event. run a select query and say hey MS Certified = 5 for number of questions so write the number 5 into the number of questions text box. any help would be appreciated.

[tmcrouse]

Have tried this:

private sub skill_click()
me.textboxnumquestions = me.comboboxskill
if skill.value = [skillstable].[skillsrequired] then
textbosnumquestions = [skillstable].[nbrquestions]
end if
end sub


doesn't work. trying to make the combo and text look at the tables and respond correctly

[tmcrouse]

actually I got it.

I made my combobox choose all rows in table. My boss had only 1 row choosen. I saw that. Then I changed all the columns to 1";0"; etc. Then in my event I did after update and put in the code:

private sub skill_afterupdate()
me!numquestions = me!skill.column(6)
endsub

[RuralGuy]

Excellent! Are you ready to follow the link in my sig and mark this thread as Solved?