title: How can I get the value of an unbound column in a combo box?
body: <p>How can I get the value from an unbound column in a combo box into a VBA variable?</p>
  
  <p>I've got a combo box called <code>cmbEmps</code> that has a Row Source that looks like this</p>
  
  <pre><code>ID   Name    Active
  1    Bob     -1
  2    Jim     -1
  3    Jane    0
  </code></pre>
  
  <p>It's bound to a field on my form on column 1, and my column Widths have been set to 0";1";0" so that only the name is displayed.</p>
  
  <p>What I'd really like to do, is when Jane is selected, find out out that the <code>Active</code> column (3) is 0.</p>
  
  <p>How can I do this?</p>