When I run code by pressing the Run toolbar button from a module, everything is OK. However if I run the code via a macro using the RunCode, the routine is run OK but it crashes at the end of the process.

has anyone come across this before?

if you already have tried compact/repaire and creating new db >> importing all your objects to it and the problem persisted , post the code it might be your real problem.

I created a new DB and imported all the objects and it's OK now. Thanks.

glad to help , above technique for ms access is quite like restart for computers when they go crazy on you :)

One thing that might be different, though ...

RunCode as a macro requires that the code is a function, not a subroutine, because the macro manager wants to test the return status.

Run from the toolbar doesn't have that limitation, I think. So you can run a subroutine that returns nothing.