fill a combo box programmatically

M

Mary

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.
 
A

Allen Browne

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.
 
Top