title: Reference a field on a form within a query using SQL
body: <p>I have an Access 2007 database that will be housing tables which refer to the bill of materials for multiple products.  On the main form I want a user to be able to select one of the products - OK, easy.  Now, I want two queries to run once they press a button after choosing their product from a dropdown.  The first query is a simple delete query to delete all information on a table.  The second query is where I'm having my issue with my SQL syntax.  I want the information from a static table to be appended to the table where the delete query just removed everything from.  </p>
  
  <p>Now, each table that houses the bill of material for each product is labeled with the product's name.  So I want the dropdown (<code>combo0</code>) to be the reference point for the table name in the <code>FROM</code> clause within the SQL string.  Code is as follows:</p>
  
  <pre><code>INSERT INTO tblTempSassyInfo (Concat, TableName, AddressName, PartNumber, [L/R], FeederSize, QtyPerBoard, SASSYname, RawBoard)
  SELECT TableName &amp; AddressName &amp; PartNumber, TableName, AddressName, PartNumber, [L/R], FeederSize, QtyPerBoard, SassyName, RawBoard
  FROM [FORMS]![DASHBOARD]![Combo0];
  </code></pre>
  
  <p>So you can see where I'm trying to reference the product name in the dropdown on the form as the table name.  Please let me know if this is possible.  </p>