>What do you do when you have one combobox the user selects from first which determines which of two arrays will fill the 2nd combobox. I cannot seem to get the 2nd ombobox to fill from the form-level array which I got from doign a SQL on a table.

Hi Cecil,

This works for me: I have a combobox, two Form-property-based arrays and an optiongroup to choose between the arrays. I populated the arrays manually with a loop. In the Click of the optiongroup items:

With Thisform.cboarray
   .RowSource = 'thisform.aarray'
   .RowSourceType = 5 
   .Requery()
EndWith

...I can switch freely between them.

HTH,