Adding to a combo box

[eussias]

I’m trying to add some text to a Combo box once a form is loaded. If certain criteria is met, text is to be added to the combo box… Does anyone know the easiest way to do this?? Thanks in advance

 

[tomschafer]

Assuming your combobox is a value list you can do this, where Combo0 is the name of the combo box on your form. Make sure to add semi-colons after each value.

Me.Combo0.RowSource = Me.Combo0.RowSource & "NewText;"