Code to Update Combo Box Contents

[jess]

Ok, this should be a fairly simple task and may not need to be handled with VBA code, but here we go:

I have a combo box that is filled with different Categories by a query. Each Category has a unique ID with it in the Categories table that the query pulls from.

A second combo box should look up the value of the Categories combo box and display a list of Skills that are of the selected Category. I have a table set up with all the Skills listed with each assigned an ID matching the Category they belong in.

So, should/can the second box be built via a query or should/can it be built via some VBA code?

I believe that Category.Value should get the value currently selected in the Category drop-down menu, but I do not know the code to add or delete items from the second combo box.

Thanks,
Jess

 

[RichMorrison]

jess,

This is the most popular question in the forum.

Do a search on "cascading combo".

You will find lots of examples.

RichM

 

[DBL]

Here's a sample that you might find useful

 

[DBL]

Oops!

 

[RV]

There are a lot of posted topics on this issue.
Search the Forms section for *combobox*.

RV