[AccessD] JIT Forms

Rocky
...JC's JIT code was the first thing I bought when I was starting out in 
Access ...he was still living in Pueblo, Mexico back then ...we had many an 
AccessD discussion about which was the best way to do this ...anyway, he 
used to keep a copy on his website (which is stll a disaster area) but I 
can't find it now ...so I zipped a code library copy I have of his code, an 
A2k3 version, and sent it to you offline.
William
----- Original Message ----- 
From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Thursday, November 08, 2007 5:32 PM
Subject: [AccessD] JIT Forms


> JC:
>
> I have a form with about 16 tabs, a bunch of combo boxes, and a bunch of
> sub-forms.  It will not surprise you to learn that it is taking an
> unacceptably long time to open - 60 seconds on a smallish database over a
> wireless connection to my laptop (trying to simulate a slow server).
>
> I remember something about a form like this that you had and, I believe,
> loading the combo boxes and sub forms only when a tab got the focus?  The
> combo boxes are bound so I can't wait to put in the row source until 
> they're
> clicked.  But I could load the row source when the tab was activated - 
> store
> the row source in the tag and load it if it's not there.  But there's no
> activate or got focus event for a tab.  There is a mouse move event but 
> I'm
> not sure that will do  to trigger loading of the Row Source and the
> sub-forms.
>
> How did you solve the problem?
>
> Regards,
>
> Rocky
>
>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com