Filling a two column combo box with VBA code

I have a table with two field in an MS Access 2003 database.  I would like to populate a two column combobox with the data from the table using VBA code.  How do I do that?
kshumwayAsked:
Who is Participating?
 
dqmqCommented:
Why VBA code?  
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Set the combos ColumnCount=2, and ColumnWidths=1;1

Set the RowSource as "SELECT YourFirstColumn, YourSecondColumn FROM YourTable"
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.