title: Access VBA: Find item in combo box based on non-bound column
body: <p>I have a two-column combo box on an Access form representing a key-to-code mapping. The first column of the combo box is the 'bound column' (ie, the column used when <code>MyComboBox.Value</code> is called).</p>
  
  <p>I need to dynamically set the <code>Value</code> of my combo box based on a value found in the second column. For eg, if my combo box source is:</p>
  
  <pre><code>Value | Code
  ===============
   A1    | ABCD
   A2    | EFGH
   A3    | IJKL
  </code></pre>
  
  <p>I can set the value of the combo box simply with <code>ComboBox.Value = "A2"</code>, but how would I do the same using the second column? <code>ComboBox.Value = "EFGH"</code> obviously isn't valid. Essentially looking for logic along the lines of <code>ComboBox.Value = ComboBox.ValueWhereSecondColumnEquals("EFGH")</code></p>