lee_jd
asked on
Fill a 2 column combo box from an ado recordset
I have an ADO recordset with 2 columns,
I want to populate this into a combo box.
I've tried using the .AddItems in a loop through the recordset but this only works with 1 column.
I'm using Access 2010. Any ideas?
I want to populate this into a combo box.
I've tried using the .AddItems in a loop through the recordset but this only works with 1 column.
I'm using Access 2010. Any ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
...and post the relevant properties of the combobox...
I am sure you were just missing something like setting the column count to 2, or having set the column width of a column to 0
...or missed something like this in the code
rst!Col1=...
rst!Col2=...
JeffCoachman