how to delete values from combo box??? 1

[notageek7]

I've looked through the other forums and FAQ with their suggestions not working....I'm not sure why. I've got a combo box that was filled by ..AddItem from an array. I need to empty, all the values, when a value from another combo box is chosen. I've tried the techniques below with only the value shown getting deleted, the other values are still there in the drop down list. It seems I tried all variations of what I found suggested. How can I empty all values from a combo box??? Any help would be appreciated.

combo1.value = ""
combo1.value = Null
combo1.value = Empty

combo1.text = ""
combo1.text = Null
combo1.text = Empty

 

[RoyVidar]

Try:
[tt]me!combo1.rowsource=vbnullstring[/tt]

- or you could loop and use .removeitem, I guess

Roy-Vidar

 

[notageek7]

RoyVidar, thanks again for your help!!!! Your first option worked great.

me!combo1.rowsource=vbnullstring