title: Runtime 3075 Inserting apostrophe
body: <p>I'm very new at this, so I'm a in a little over my head.</p>
  
  <p>I'm working with an access form that inserts employee attendance information into a table. It works perfectly for the most part. The problem comes when there's an apostrophe in the "Notes" text box. I can't seem to find a workaround. </p>
  
  <pre><code>If Not IsNull(Me.lstStudentID) And Not IsNull(Me.cboShiftLocation) And Not IsNull(Me.txtShiftTime) _
  And Not IsNull(Me.cboInfraction) And Not IsNull(Me.txtDate) Then
      CurrentDb.Execute "INSERT INTO tblDiscipline(UOID, Infraction, Shift_Date, Shift_Time, Shift_Location, [Notes]) " _
      &amp; " VALUES ('" &amp; result &amp; "','" &amp; Me.cboInfraction &amp; "', '" &amp; Me.txtDate &amp; "', '" &amp; Me.txtShiftTime &amp; "', '" _
       &amp; Me.cboShiftLocation &amp; "', '" &amp; me.txtNotes &amp; "')"
  </code></pre>
  
  <p>Thanks in advance.</p>