Need to refresh the table

[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.

 

[Steve Schapel]

Crazy,

As you said, refresh. Add this action to your macro:
RunCommand / Refresh