I have a saved Macro that runs a Delete Query, an Append Query, another Delete query, and a MessageBox. The Macro runs exactly as expected when run using the Run action or doubling clicking on it.
When I attached this macro to the On Delete action of a form the macro appears to run. However, the Append query does not perform as expected. Has anyone ever encountered this problem? Is there a fix for this?