]]>By: chippy088http://itknowledgeexchange.techtarget.com/itanswers/access-2010-macros/#comment-87492
Thu, 03 Feb 2011 15:38:37 +0000#comment-87492We need to see the whole of the macro code to make any suggestions.

Without looking at the code, I’d suggest closing the table and report in the macro. It seems it is terminating abnormally with the tables and report still left open, that’s why you have to manually close it down.

Do you get a debug report from the macro? That might give more suggestions of what is wrong.