title: MS access combo box get selected item value
body: <p>Hello - </p>
  
  <p>I'm using MS Access and I'm using a form to run a query. The form has two text boxes, a combo box and a button.</p>
  
  <p>All three provide criteria for the query and the button runs the query when it is clicked. Currently the text boxes are working and they provide the criteria for the query.
  The combo box is bound to data from another table and is currently not providing the criteria to the query.</p>
  
  <p>What I would like to do is that when I select an item on the combo box and I run the query using the button, the selected item is the one used as the criteria in the query. </p>
  
  <p>If this requires vba code I would really appreciate if you showed me how its done.</p>
  
  <p>Thanks</p>