title: How can I stop Access from displaying #DELETED after a record update?
body: <p>I have an access 2016 database pointing to a MySQL backend.  I have a form with a subform.  The subform is in continuous form view.  </p>
  
  <p>I made a chance to the entry of the subform and now when my users tab through the creation of a record to the next record the record just created displays #Deleted in all the text box fields.  Hitting <kbd>F5</kbd> corrects the problem but it's an extra step I want to avoid.  </p>
  
  <p>Here is the code I added.</p>
  
  <pre><code>Private Sub cboOperationNUM_AfterUpdate()
  
      If Nz(DLookup("[autoOut]", "[dataDetailOperations]", "[dataDetailOperations_NUM] = " &amp; Me.cboOperationNUM.Value), "") = "" Then
          Exit Sub
      ElseIf DLookup("[autoOut]", "[dataDetailOperations]", "[dataDetailOperations_NUM] = " &amp; Me.cboOperationNUM.Value) = -1 Then
          Me.opOutsourcedPO.Value = 0
      Else
          Me.opOutsourcedPO.Value = Null
      End If
  
  End Sub
  </code></pre>
  
  <p><a href="https://youtu.be/gz4jHOcVCyM" rel="nofollow noreferrer">Video Capture of the problem</a></p>
  
  <p>If an Outsource Operation is select it enters a 0 into the PO field.  If not an outsourced operation it enters a NULL.  What I have found is if the PO field (int(5) in MySQL) is set to a number and then made blank (NULL in VBA or deleted from the form), when the record is updated it shows #Deleted until a refresh.  If I comment out the Else portion of my code everything seems to work but it doesn't empty the PO field if the operation is not outsources.  This is functionality I'd like to keep.</p>
  
  <p>Any ideas?</p>