title: Access combobox store 1 value, display another
body: <p>I'm have a query that returns the following columns:</p>
  
  <p>Code<br>
  LastName<br>
  FirstName   </p>
  
  <p>I have a combobox where all of this info is displayed in the dropdown.  But when I select a row, all I see in the combobox is the Code (its an employee number).  What I'd like to do is display:</p>
  
  <blockquote>
    <p>"[Code] - [LastName], [FirstName]"</p>
  </blockquote>
  
  <p>as the selected item when a value is selected, and still store just the [Code] in the combobox's .Value property.  </p>
  
  <p>How is this done?  I'm used to C#.NET where a dropdown has 2 properties (displayValue and selectedValue).</p>