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?
 
dqmqConnect With a Mentor Commented:
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
All Courses

From novice to tech pro — start learning today.