When I insert a new record on the form, and refresh record, the table will not reflect the change until I sort the ID column in the table or close and reopen the table to see the new record appear. and if I delete a record from the form, the "#deleted" appears in every field of that record in the table, I would also need to sort the ID column or close table to make that record disappear. Is there a way to stop this extra step? Thank you.