My application is now running with the changed $Insert record. David Sigafoos had mentioned doing a tree compile on each of the forms via the app manager. Though tedious this did the trick. I took a look at the engine output and it looks like it was doing a TCOMPILE. I then fugured this is what I sould have been doing from the stored procedure. Then I noticed Cameron had posted some code that included the TCOMPILE so this would have done the trick too.
I'm still a bit curious as to why the programatic COMPILE on each of the window's events did not work even though the status from each was a 0. Since some of the windows failed to compile I wonder if the code was bailing out at some point. The windows that failed had a ]64K error os some type. ( I can't remember the error off hand right now)
Thanks again for your help.
Bryan