title: MS Access Pulling value from combobox in where condition using macro builder
body: <p>I am trying to pull the value the user selects from a combo box in a <code>Where Condition</code> for a macro.  The Row Source for the combo box is a table where the first Column is the id numbers and the second Column is the data that the user chose.  </p>
  
  <p>I have tried both of the below statements with no luck</p>
  
  <p>1) <code>[Query]![value]=[Forms]![Main Menu]![Combo]</code></p>
  
  <p>2)  <code>[Query]![value]=[Forms]![Main Menu]![Combo].[Column](1)</code></p>
  
  <p>Where <code>combo</code> is my combo box
  The first one I know is pulling the ID number which is not what I want.  I have manually entered in a text box and found that if i set up my macro to match whats in the text box it will work correctly.</p>
  
  <p>How can I pull whats on the second column instead of the combo box?</p>
  
  <hr>
  
  <p><strong>EDIT</strong></p>
  
  <p>The workaround I found was I now instead did an <code>after update</code> on the combo box to fill an invisible textbox, then i instead used that to pull the value I needed.  </p>
  
  <p>Such that:
  <code>[Query]![value]=[Forms]![Main Menu]![textBox]</code></p>