VB code to add items to a Combo Box

[RobinF]

I need the VB code to add items or names to a Combo box

 

[Graham R Seach]

Robin,

If your combo box gets its data from a table, then you need to add data to
the table, then requery the combo:
CurrentDb.Execute "INSERT INTO tblTable (Field1, Field2) VALUES (1,2),
dbFailOnError
Me.cboMyCombo.Requery

If your combo gets its data from a list you've provided, you can add to that
list at runtime:
Me.cboMyCombo.RowSource = Me.cboMyCombo.RowSource & ";" & strSomeText

....but, the latter example will only be temporary. It won't be there next
time you open the form. To make it stick, you need to open the form in
design view, save the additional data to the combo, then save and close the
form.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia