<div>
Why not create a table for those values and use the table as the combo boxes recordsource. &nbsp;This would be far easier to maintain, in the long run, than hard coding it.
</div>


Why not create a table for those values and use the table as the combo boxes recordsource.  This would be far easier to maintain, in the long run, than hard coding it.

<div>
To answer Dale Fye, &nbsp;<br />
<br />
I am populating the combo box from different tables based on arguments to the function.<br />
<br />
<br />
Thanks all for the help. &nbsp;Excellent!!
</div>


To answer Dale Fye,  

I am populating the combo box from different tables based on arguments to the function.


Thanks all for the help.  Excellent!!

<div>
<div class="content wysiwyg-content">
I am using Access 2013.<br />
<br />
I have a combobox with 2 columns. &nbsp;The first column is a string. The second column will hold a number<br />
The data just mentioned will be held in a 2 dimensional array, so I want to populate the combobox whilst in a loop.<br />
<br />
I can populate the first column easily enough, but am having trouble populating the 2nd column of the combobox.<br />
<br />
Would appreciate help.<br />
<br />
Thanks.
</div>
</div>


I am using Access 2013.

I have a combobox with 2 columns.  The first column is a string. The second column will hold a number
The data just mentioned will be held in a 2 dimensional array, so I want to populate the combobox whilst in a loop.

I can populate the first column easily enough, but am having trouble populating the 2nd column of the combobox.

Would appreciate help.

Thanks.

Populate 1st &amp; 2nd column of a combobox using Access 2013 VBA

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Populate 1st &amp; 2nd column of a combobox using Access 2013 VBA

Populate 1st & 2nd column of a combobox using Access 2013 VBA