>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,