forms load slowly.

[Hitesh Joshi]

Hi,
I am an MS Access newbie.
I have a form with two subforms. Main form and subform both quries the
SQL db though ODBC link. When I run main form and subforms
independently, they are very fast but as soon as I put them together in
a single form (main form + subforms), it takes 3-4 seconds to load.
There are not any complex calculation involved.
Is there anyway I make this load fast or atleast make it appear
faster.. like load main form and then have a button that can make
subforms visible?


Thank you,
hj

 

[LLKHOUTX]

Use the Debugger to single step throouh your form's code (maybe, the ONOpen
evnet) to see what taking so long.

I'll bet that there is some code is being executed multiple times.

 

[RoyVidar]

Hi,
I am an MS Access newbie.
I have a form with two subforms. Main form and subform both quries
the SQL db though ODBC link. When I run main form and subforms
independently, they are very fast but as soon as I put them together
in a single form (main form + subforms), it takes 3-4 seconds to
load. There are not any complex calculation involved.
Is there anyway I make this load fast or atleast make it appear
faster.. like load main form and then have a button that can make
subforms visible?


Thank you,
hj

I'm sure, if you take the time to search these groups with terms
relating to performance, you will find much information. Then there
are also those who have compiled a bit of information on the topic,
like for instance

http://www.granite.ab.ca/access/performancefaq.htm
http://www.fmsinc.com/tpapers/faster/index.html