First, thanks all you folks who are trying to help solve this!
Jeremy, regarding you question:
It does get to the "End If", and it opens the form, if necessary, just fine. It also tries to execute "StartSystem", but can't find "StartSystem".
From the code above, "StartSystem" is located in "testcodelib.mdb". Form "frmResetAttachedTable" is located in "codelib.mde". So, "textcodelib.mdb" can find and open and execute anything in "codelib.mde."
Here's the steps:
1) Code in textcodelib.mdb runs a function in "codelib.mde" called .
2) The function in "codelib.mde" opens a form which reside in "codelib.mde". It waits for use input.
3) Once that form opens, I can not seem to reference any object from "textcodelib.mdb" such as another form, macro, or other functions or subroutines such as "StartSystem". I can reference (execute) anything in "codelib.mde".
4) If I attempt to execute code(run "StartSystem" in this example) or open a form (Docmd.openform "fmrAssets"

which resides in textcodelib.mdb, it will tell be it's not there.
Note however I something in the system know about them because if I put a breakpoint at the line that dies, I can go to the immediate window and execute:
?application.currentproject.Allforms.item("frmAssets"

.name it will show me it's name. I can do that with a number of the form properties. But I can't day:
Docmd.Openform "frmAssets"
It gives me an error code that it can't find the object.
To summarize:
It appears that if I execute code in codelib.mde, unless the code is a function that returns back to the caller, I can't get the execute stream out of codelib.mde and back into testcodelib.mdb.
If anyone wants to duplicate this, you can do it in about 2 minutes as follows:
1)Create a new MDB called codelib.mdb. Add one form called frmCodeLib. Put one button on it that executes:
Docmd.Openform "frmMain"
2)Create a second new mdb. All one form called "frmmain". Add one button on it that executes:
DoCmd.openform "frmCodeLib"
When you in the VB windoes. go to Tools > Refererence. click browse, and add a refernce to the codelib.mdb (you don't even need to make this an .mde yet)
3) Open the "frmMain" form. It should work find and you should get the frmCodeLib from opened.
4) Close the frmMain form, now click the button on the frmCodelib form. It will give you an error that it can't find "frmMain" BUT if you go to the immediate window and use the ?application... line above (change the form item to "frmmain"

you will see it can in fact see it.
Sorry this is so long winded.