not loading subform with parent

[Guest]

I would like to know which properties I need to call to not load a subform
with its parent until all of the on load coding has completed. The reason for
this is that I have a single subform which displays results from a temporary
table created when the parent form is loaded which is based upon the access
level the individual has. This temporary table remains until the parent form
is closed.

 

[Guest]

There are a couple of things that may take care of your problem. First you
could try requerying the subform after the temporary table has been created.
If that doesn't do it, try setting the source object of the subform control
in design view. Set it as the last statement in the form's Load event.
Although it seems intuitively incorrect, a subform actually loads before it's
parent/

 

[Guest]

I tried doing a requery on the forms... this did not fix the problem. Tried
changing the forms source object in design view and as the last statement in
the load event... this did not fix it either. I believe this is because both
were based upon a temporary table that was created as the same parent form
was loaded and thus after the sub forms were already loaded. To work around
this problem I created an additional form that opens while a splash screen is
visible and runs in "hidden" mode. This form does the access level checking
and then runs the query to create the temporary table. Having this event
happen seperately from the load event of the parent form has solved the
problem and actually helps to load the main form much faster.

Thanks for your help.

 

[Guest]

Actually, a very good solution.