Need to refresh the table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is really silly. I used to know how to do this! And, perhaps a macro
is not the best place to accomplish this, but actual code.

I have a macro behind a button on a form that simply takes the current
record, appends that record to a 2nd table (macro runs an append query), then
deletes the current record from the table that is the source for the form
(macro runs a delete query).

Now, the current record shows all the fields as "#Deleted". Would like a
complete refresh of the table to completely remove that record.
 
Back
Top