fill a combo box programmatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i want fill a combo box with records from a defined ADO recordset. i like to
include more than one fields and also specify the bound column so that i can
use it later.
 
If the combo's RowSourceType is ValueList, you can use the AddItem method of
the combo to add the items. See Help for details and example.

You could also loop through your recordset, concatenating the values into a
long string with the correct delimiter, and assign that to the combo's
RowSource.

But it woud be simpler to leave the combo's RowSourceType as Table/Query,
and just assign whatever SQL statement you used to open your recordset as
the RowSource of the combo.
 
Back
Top