title: Running an SQL string in VBA?
body: <p>Iv created the SQL string sql in ms access vba but when it runs it prints the string in the debug window but doesn't actually run the string to add a record to the table like I want it to.</p>
  
  <pre><code>Public Sub EmpoyeesTable_Click()
  
      Dim sql As String
  
      sql = "INSERT INTO Employees " &amp; _
      "VALUES " &amp; "(1, 'James', 'Dan', 'n6 indro Rd', 0943747, 30.24);"
  
      Debug.Print sql
  End Sub
  </code></pre>
  
  <p>Ultimately I want to use SQL strings to take input from a form when submit is clicked and add it to a table? Is this even the right approach? </p>