title: Insert Into Access Table Form
body: <p>I have a table I created and its purpose is to house a database of queries i have created over the years, I created a corresponding form to insert all the information but I am having trouble getting the code to work.</p>
  
  <pre><code>Private Sub cmd_go_Click()
  Dim insertstring As String
  
      insertstring = "INSERT INTO KWTable (KW, Source, Code) VALUES (" &amp; text_key.Value &amp; "," &amp; combo_source.Value &amp; "," &amp; text_code.Text &amp; ");"
  
      DoCmd.RunSQL insertstring
  
  End Sub
  </code></pre>
  
  <p>The three columns on the destination table are KW, Source, and Code the values being inserting into them are text_key (which are keywords that I type in so i can search them later when i need to reference certain things), combo_source.Value (which is a combo box with the list of databases where these codes and queries are saved, which i will select the right one when inserting into the table) and text_code ( which is the actual code itself of the query)</p>
  
  <p>The code is supposed to insert the keywords (text) the source (combobox listing) and the code (text) into the KWTable. But when I click the add record button I get a "Runtime Error 424: Object Required" Error box and it has the whole insertstring line highlighted. I cannot troubleshoot where the error is. Any thoughts?</p>