title: Inserting current DateTime into Audit table
body: <p>I am in the process of implementing an audit log to record a <strong>brief</strong> description of changes to the database. My audits table consists of an autonumber PK, empID(number), Description(memo), and auditDate(date/time). My empID and description are being properly inserted without throwing errors, but my date/time is not being inserted. I am thinking this may not be as simple as misplaced quotation marks. My VBA code is as follows:</p>
  
  <p>in the afterInsert event:</p>
  
  <pre><code>Dim strQuery As String
  'Dim js As Integer
  Dim currDateTime As Date
  currDateTime = Now()
  
  
  strQuery = "INSERT INTO Audits ([emp Number], Description, dateofAudit) VALUES (" &amp; Me.empID &amp; ", '" &amp; "insertion" &amp; "'," &amp; currDateTime &amp; " )"
  
  
  CurrentDb.Execute (strQuery)
  </code></pre>
  
  <p>Like I said, I can get the first three values in fine, but when I attempt to insert the date time, I run into problems. Any input is appreciated. Hopefully this is not as simple as misplaced quotation marks, as I tried about 4 variations of quotation mark placement before submitting this question:)</p>