Half the load time occurs before the form_Open event?

[rudeboymcc]

Hi. I have a split form based on a pass through query with only 400 records. The form however has loads of controls (about 20).

The passthrough query opens in less than a second, but the form takes nearly 6. this is too long as it's the main form of the program.

Trying to find out what's taking so long, i put some messages in different parts of the vba code and found that before the form_open event, there is at least a 2 second wait.

What could this be?

the button to open the form is the standard switchboard so there's nothing else happening before the docmd.openform code.

EDIT: Using ACcess 2007 SP2 on Vista SP2 with SQL Express 2008 as backend

 

[namliam]

This is probably the time to build the connection to the backend database

You could try (when the switchboard opens) to force a building of the connection by doing a "select sysdate from dual" (thats oracle speak dont know SQL Express speak)

 

[rudeboymcc]

but then why when i run the passthrough query directly (which also needs a connection to the database) does it not delay?

 

[namliam]

Probably because the connection is already build before you manually run it.

 

[DCrake]

Here is a link to a FAQ I placed here ages ago. This may help you in some way.