Macro hangs access when started by button

[SirAnon via AccessMonster.com]

I have a macro that uses 3 queries to pull data from some linked tables and
add the data to an existing table. When I run the macro from the Macros
menu, it works fine.
However, when I click a button on my switchboard that activates this same
macro, the macro runs (correctly) and then Access hangs as soon as it's
finished. Any ideas how to connect a button to this macro without causing
Access to freeze up?

Thanks for your help.