title: How to prevent an Microsoft Access error message from populating when trying to close a form?
body: <p>I have this form in Access with a bunch of drop down menu boxes.  If I choose a value from the List and then change my mind and leave it blank again, click close, I always get this message:</p>
  
  <pre><code>the data has been changed
  
  Another User edited this record and saved the changes 
  before you attempted to save your changes
  
  Re-edit the record.
  </code></pre>
  
  <p>I have 3 different macros in the background running for </p>
  
  <p>Deal type<br>
  Loan Exception Comments<br>
  Update Flags</p>
  
  <p>I don't think those macros would affect anything to give that error.  But can I write something so that it catches this error message and ignores it and proceeds to close when I click close? </p>
  
  <p>The main form VBA has this code:</p>
  
  <pre><code>Private Sub Close_Click()
   Me.FrmJobDetails.Form.Requery
   Me.subform1.Form.Requery
  
  If Me.FrmJobDetails.Form.Dirty = True Then 'what I tried adding
   me.FrmJobDetails.Form.Dirty = False 'what I tried adding
  End If
   If Me.subform1.Form.Dirty = True Then 'what I tried adding
   me.subform1.Form.Dirty = False 'what I tried adding
  End If
      DoCmd.SetWarnings (WarningsOff)
      DoCmd.Save
  
      entry
      DoCmd.OpenQuery ("aqrySBORequestSiteDetail"), , acReadOnly
  
  
      DoCmd.Close
      DoCmd.SetWarnings (WarningsOn)
  
  End Sub
  </code></pre>
  
  <p>In that code, with the comment "what I tried adding" is what I thought could prevent that error message from occurring. </p>
  
  <p>Any suggestions? </p>