Form takes a long time to open

[Jean-Guy]

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

 

[Rich]

What contols are on the form?

 

[Pauldohert]

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.

 

[Jean-Guy]

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

 

[RuralGuy]

Here's a link you may find useful. Microsoft Access Performance FAQ

 

[Jean-Guy]

Here's a link you may find useful. Microsoft Access Performance FAQ

I’ve loaded the combo boxes at load time (i.e. On Got Focus event procedure for Me.txtSomeField.RowSource = "SELECT …") as suggested in http://www.granite.ab.ca/access/performanceforms.htm, and it significantly loaded much faster!

Thanks for the tip RuralGuy!

Jean-Guy

 

[RuralGuy]

Glad Tony and I could be of assistance.

 

[Rich]

Glad Tony and I could be of assistance.

 

[RuralGuy]

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.

 

[Keith Nichols]

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?