Thanks for the tips.  In reality it turned out to be something cosmetic.  In Win 2000 when you have the design screen open, the toolbar is visible in the window...

The transaction in your sub-procedure will rollback but you will need to tell the calling procedure to rollback if it receives an error message otherwise it will commit everything else...