title: Define table in select query from the value of a text box
body: <p>I have a very basic select query in MS Access. The only variable is that I want the user to select the region from a drop down list (combo box). There is a different table for each region, so I want the FROM field to pull from the combo box.</p>
  
  <p>My query looks like this:</p>
  
  <pre><code>    SELECT
         STOCK_CODE, STOCK DESCRIPTION
  
      FROM
         Forms![frm_MAIN_MENU]![txt_MAIN_MENU_REGION]
  </code></pre>
  
  <p>When I run this I get the following error:</p>
  
  <p>"Syntax error in FROM field"</p>
  
  <p>I think I have read somewhere that this is not possible? If someone can perhaps clarify?</p>
  
  <p>Thank you</p>