Sorry for the delay.

Since you only have two dropdowns, the quick and easy solution is just to copy the SQL routine to the second dropdown (listbox).

If you have a lot of drop downs to populate, then I might write this different. I'd put the main SQL routine in Module1 and call it from each Change event.

Hope this helps!