title: How do I set up a criteria using the second column of a combo box in MS Access?
body: <p>I have a combo box that selects an angle.
  I want to use this angle as a limit.</p>
  
  <p>The combo box uses this table:</p>
  
  <p><img src="https://i.stack.imgur.com/2xSML.jpg" alt="Table"></p>
  
  <p>The combo box displays column(1) (BaseCoordinates)</p>
  
  <p>I need to create a criteria in a query like this:</p>
  
  <p><img src="https://i.stack.imgur.com/jGNOD.jpg" alt="Criteria"></p>
  
  <p>But of course it picks the ID as it is the first column.
  I have fixed this earlier by not having an ID on the table, but i don't like that because it may order the numbers in a way I don't want it to, if i have only the column with the values.</p>
  
  <p>I have tried doing <code>forms!f_main!WindSectorCombo.Column(1)</code> but it can not recognize the variable.</p>
  
  <p>In VBA, it can easily find the variable - The problem is in the query.</p>
  
  <p>Any suggestions?</p>