Greetngs. I have a form with several subforms and I have set it up so that if the user enters a number on subform 1 it fills in some information and moves to subform 2 (after update). If the user doesnt enter any information, the focus moves to subform 2 without adding any data (on exit). This all works great until I shut down the form and then I get all kinds of 2450 errors because the main form evidently closes before the subform and therefore, it can't find the forms so I get the error that access cannot find the form.

How do I set something up so that when I close the form, all the code that is set to fire on the subforms does not execute. Alternatively, how do I tell the app to close the subforms first and then the main form?

ANy ideas are VERY appreciated!!

Rick Oberle