What I ended up doing was the following:

The results of the 2nd combobox were dependent on whatever the user picked in the first combobox, so I made two comboboxes as the 2nd one and made one invisible based on the selection and one visible and one combobox was liad directly over the top of the other. That actually worked. I am not saying it's the best way to do it, but it does work. I also used the RowSourceType as 5 or Array.