Apologiez for the cross-post. Won't happen again. Although even after adding the reference the code still won't run all the way through. It stops right at
appAccess.DoCmd.RunMacro "qry_MakeTrustTable_Adhoc"
and displays a blank pop up box. Could it be a warning? It also doesn't do any of the code afterward. I double check the macro name and that is not the problem. He is a screen shot of the pop up I get.
Bookmarks