I'm using a combo box to select a category. All entries in a database that fall into this category then populate a listbox.

Based on the user's selection within that list box, i want to populate 4 more listboxes.

I have this working so far using a AfterUpdate() sub for the combo box.

However, when trying to use Click() or AfterUpdate() for the list box, i can successfully get the next series of listboxes to be populated only once. If i select the first thing in the list, the boxes are filled correctly. However, if i click on something else, the code does not run again (leaving the data corresponding to the first list item), unless i change the combo box and repeat the entire process from the start which is not ideal.

Does anyone know what I can do to make this code work twice in a row?