title: Syntax for Insert into VBA access
body: <p>I have an unbound form that I use to add records to a table. I am just using the name of the field in the values() list without any &quot;&quot;&quot;&quot; or &amp; and it seems to work fine. Is there a problem with this syntax?</p>
  <pre><code>DoCmd.RunSQL &quot;INSERT into Patient2 (LastName, FirstName, MiddleInitial, SSN, MRN, DOB, GenderID, RaceID, HispanicorLatino)&quot; &amp; _
          &quot;VALUES (LastName, FirstName, MiddleInitial, SSN, MRN, DOB, GenderID, RaceID, HispanicorLatino)&quot;
  </code></pre>