Add and Remove item from Combo box by code

[miki]

Hi All...

How can I Add and Remove item from Combo box by code,When the RowSourceType ="Value List" ?

thanks.

 

[Jack Cowley]

I think you need to rethink your approach to using a combo box with a Value List. How about using a query instead? Hard to advise you when we don't know why you want to change the list and what the purpose of the combo box is.

But to answer your question, yes you can change the Value List using code. This will work:

Me.ComboBoxName.RowSource = "D;E;F"

[This message has been edited by Jack Cowley (edited 02-17-2002).]