Waiting for form to load

[chasday]

I have a form with several cascading subforms. Everything works OK but it
takes several seconds for all the subforms to load and for all the calculated
textboxes to populate.
Is there a way to lock the user from the form until it is completly loaded?
I have tried to use Application.Echo = True/False on either side of the Form
Load code but so much happens after the main form is loaded that it doesn't
seem to help.

 

[Klatuu]

I don't know of any way to do what you are asking. The problem is with
multiple subforms, it has to populate the recordsets for all the subform and
then the main form. (believe it or not, the subforms load before the main
form) You may need to reconsider your design with performance in mind.

 

[Minton M]

I don't know of any way to do what you are asking. The problem is with
multiple subforms, it has to populate the recordsets for all the subform and
then the main form. (believe it or not, the subforms load before the main
form) You may need to reconsider your design with performance in mind.

Yeah, anything you try is going to be a fudge... I'm with my good
friend Dave.