Have a combo1 that has a rowsource of an array. Also have a two column list1 that has more detail about the selected combo1. Each selected combo1 can have a different number of rows in list1. Trying to get a handle on the array(s) to have as the controlsource of these two controls and how to change the controlsource of listbox1 when combo1 changes.

combo1 list1
----- -----
Table ethan allan, 4
thomasville, 3
Chair watson, 3
Desk office depot, 7
office depot, 8
office depot, 10

want the ethan and thomasville info in the list1 when table is selected in the combo1. getting all confused about the array(s) needed for the controlsource and how to reference the array(s) in the controlsource.

thanks

brenda