Form with subforms - slow on closing of main form

R

Richard

I have a form which has 7 subforms. I only load the subforms that I need when
a user click on a button to see the subform. During the main load of the
form, the subforms's source is set to a blank form. I then switch out the
blank source with the subform that I need. This is great during the load of
the main form.

Problem is now, when I try to close the main form, it is taking a very long
time to close the window.

This only happens if I am using Access 2007. Works fine in other previous
version.

Does anyone have any idea what is going on?
 
Top