title: Handling #DELETED messages on records that have been deleted while a form is active
body: <p>There may be a better way to do this, but currently, if the user enters i value that is not allowed (in this case, a project that has been closed), then it notifies them. However, because it's on a sub-form linked to the table, it automatically created a record anyway. This is how it's currently handled (if a bad input was entered):</p>
  
  <ol>
  <li>Clear the fields of that record    </li>
  <li>Delete the record from the table</li>
  <li>Requery / Refresh</li>
  </ol>
  
  <p>Currently it works fine, except it leaves #DELETED in all the controls associated with the records. However, if I hit F5, it disappears. Is there a way to make it so the deleted record disappears (like how it does when F5 is hit) programmatically?</p>