Form takes a long time to open

Jean-Guy

New member
Local time
Today, 14:05
Joined
Sep 26, 2003
Messages
8
I have a form that takes a long time to open – around a minute and sometimes longer. The form is based on a query, and this query on its own opens almost right away. Why would a form take so long to load up? What factors can increase a form’s load time?

Jean-Guy
 
One thing that works, though I don't think its generally recognised. Saving some of my forms directly BEFORE closing them makes them run better than closing them then accepting the invite to save them.

Don't know why this is, but on certain form this works.
 
I have 6 combo box controls that are based on queries that have as filter criteria, the values of other controls of the form itself. Other than that, there are about 25 text boxes for fields of the query that the form itself is based on.

I believe the problem has to do with the 6 combo boxes since I’ve created a new form (for test purposes) with only text boxes for the same query that the other sluggish form uses, and this test form opens almost instantly!

Jean-Guy
 
Last edited:
Tony Toews @ Granite Consulting, the link I gave Jean-Guy. Tony really did all of the work and I just memorized his web site location. :D
 
Pauldohert said:
Saving some of my forms directly BEFORE closing them makes them run better than closing them then accepting the invite to save them.

Don't know why this is, but on certain form this works.

|Paul,

A couple of hops of links from RG and I found this snippet:

It also pays to clear the record sources in the Unload event as sometime these get saved with the form in Access 2000.

Private Sub Form_Unload(Cancel As Integer)
Me.RecordSource = ""
Me.cboFindRecord.RowSource = ""

Maybe your saving technique has a similar effect?
 

Users who are viewing this thread

Back
Top Bottom