"BerkshireG uy" <be************ *************@y ahoo.comwrote in message
news:11******** *************@s 80g2000cwa.goog legroups.com...
Is there an event that triggers as a form is loading? I want to
display a "loading form" event as the form is loading since it tends to
take 20 second or so to open.
TIA
Brian
I would suggest trying to find out why your form is taking so long. One
thing to try is a persistent connection to your back end file (you do have
it split, right?). You should also have a local copy of the front end file
on each user's PC which should also help speed things up. To quote Allen
Browne from another thread on this topic:
"Hopefully you have a split database, and you are working on a local (C:
drive) copy of the front end, so we are not talking about network lag on
design.
I strongly suggest you walk through each item in Tony Toews' FAQ. It is
definately worth the learning experience, and will probably identify the
cause of your issue. Also worth a compact, decompile, compact sequence.
If the slowness of the network itself is a contributing factor, you will
notice a significant delay when you open the Relationships window (Tools
menu.) This assumes there are several related tables in the back end, of
course. But that still should not make the form slow to work with once you
have it open in design view."
HTH - Keith.
www.keithwilby.com