<div>
I'd suggest adding an ID field so each row is unique and then bind your combo box to that ID field. &nbsp;It is quite possible to have two Davids who are the same age. &nbsp;So using either the name or NameAge as your key is not at all reliable.
</div>


I'd suggest adding an ID field so each row is unique and then bind your combo box to that ID field.  It is quite possible to have two Davids who are the same age.  So using either the name or NameAge as your key is not at all reliable.

<div>
<div class="content wysiwyg-content">
Following is the scenario I am dealing with...<br />
<br />
I have the combo box with two columns<br />
<br />
Name &nbsp;Age<br />
David 29<br />
David 32<br />
Peter 24<br />
Peter 25<br />
Peter 26<br />
Peter 29<br />
Maria 22<br />
Maria 29<br />
<br />
<br />
<br />
I selected Peter 26, and after selecting when I go back to drop down combo, it is always on Peter 24, how do I code it to have it keep the selection ie Peter 26<br />
<br />
Thanks.<br />

</div>
</div>


Following is the scenario I am dealing with...

I have the combo box with two columns

Name  Age
David 29
David 32
Peter 24
Peter 25
Peter 26
Peter 29
Maria 22
Maria 29



I selected Peter 26, and after selecting when I go back to drop down combo, it is always on Peter 24, how do I code it to have it keep the selection ie Peter 26

Thanks.


Acess VBA Combo box

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.