Event as form is loading

[BerkshireGuy]

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

[Keith Wilby]

"BerkshireGuy" <be*************************@yahoo.comwrote in message
news:11*********************@s80g2000cwa.googlegro ups.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

[lesperancer]

you need to find out why it takes 20 secs...
is your form bound to fields in a table ?
if so,
how many records in the table ?
at startup, is the form's recordset displaying all the records or do
you have a 'search'
button to select just one record to display ?
BerkshireGuy wrote:

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

[BerkshireGuy]

Thanks to you both for the responses.

The slowness is due to the form calculating a few values based on some
link tables that are in desperate need of optimizing. Unfortnately,
its not a system that I have access to optimize.

Thanks
Brian

le*********@natpro.com wrote:

you need to find out why it takes 20 secs...
is your form bound to fields in a table ?
if so,
how many records in the table ?
at startup, is the form's recordset displaying all the records or do
you have a 'search'
button to select just one record to display ?
BerkshireGuy wrote:

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

[deluxeinformation]

BerkshireGuy wrote:

Thanks to you both for the responses.

The slowness is due to the form calculating a few values based on some
link tables that are in desperate need of optimizing. Unfortnately,
its not a system that I have access to optimize.

Consider using the form's Open or Load events. The major difference
between the two is that Open can be canceled (if for example there are
no records to display or some other arbitrary condition is met) and
Load cannot. If you're using Access 2003 look at online help for
'order of events for database objects' and then click on 'order of
events for forms and subforms' for more information about what happens
when a form opens.

Bruce