where ComboName is the exact name of the combo box and YourValue is what you want to add to combo (if you enter a string, enclose it in double quotes).
The code works if run from within the form that contains the combo box. To run it from outside, use the syntax:
Forms("FormName")("ComboName") instead of ComboName and make sure the form is open.
The combo will display the new value after the code is run.
This works except I can't find a way to spool this from a database. I can setrowsource once, but it just gets overwritten every time after that, and sure I can use the cboname.rowsource = value "; " & cboname.rowsource = ... but I can't find a way to dynamically add new entries?
Maybe you should just replace the entire recordsource instead of looking for new entries... This solves the problem of deleted records.
Dim myrs as DAO.Recordset
Dim myctr As Control
Set myrs = CurrentDb.OpenRecordset("TableOrQueryName")
Do until .EOF
myctr.RowSource = myctr.RowSource & !FieldName & "; "
In the end, you'll have a fresh list of entries in the combo box.