title: Access 2010 Web Database How to extract a particular column from combo box
body: <p>I am creating a web database in access 2010 </p>
  
  <p>I have a combo box on which I have set the number of columns = 2</p>
  
  <p>I have also set the query to populate the combo box to </p>
  
  <p>select id, value from table1</p>
  
  <p>Now I have a second combo box for which I want to write query like</p>
  
  <p>select id, value, lookup from table2 where table2.lookup = [Forms]![Form1]![Combo1]</p>
  
  <p>but this doesn't work because its a multi column combo</p>
  
  <p>I also tried</p>
  
  <pre><code>select id, value, lookup from table2 where table2.lookup = [Forms]![Form1]![Combo1].Column(1)
  </code></pre>
  
  <p>but this is invalid syntax</p>