S
So Call Me Crazy
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.
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.