forms load slowly. "Hitesh Joshi" <hitesh287[ at ]gmail.com> 08.09.2006 17:42:17 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

RE: forms load slowly. LLKHOUTX 09.09.2006 18:42:01 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. -- LLKHOUTX "Hitesh Joshi" wrote: [Quoted Text] > 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 > >

Re: forms load slowly. RoyVidar <roy_vidarNOSPAM[ at ]yahoo.no> 10.09.2006 20:46:25 "Hitesh Joshi" <hitesh287[ at ]gmail.com> wrote in message <1157737337.378690.275650[ at ]i3g2000cwc.googlegroups.com>: [Quoted Text] > 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 -- Roy-Vidar