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?
LVL 2
lee_jdAsked:
Who is Participating?
 
Helen FeddemaConnect With a Mentor Commented:
You might be able to just use the SQL for the recordset as the combo box's row source.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Can you post the code you were trying...? and post any errors you were getting...?
...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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.