Performance Issues

[Ray S.]

I have a form with a series of unbound text boxes and list boxes and a few
buttons. What causes forms to mortally slow down? Whenever I call up the form
it takes forever to open. Also, if I switch from form view to design view, it
changes pretty quickly; but if I change from design to form view it takes
forever. What am I missing?

 

[Al Campagna]

Ray,
No way to tell for sure...
You'll just have to drill down through various apects of the form, to
try to determine the cause.

First... back up your form!
Second... back up your form!
Does the query behind the form run relatively quickly?

Using Cut and Paste, try deleting all Listboxes. Quicker?
If so, add back (paste) the Listboxes one at a time.

Then move on to your code, by removing any code that fires up to and
including the OnCurrent event. Any difference?

It's just a matter of trying to isolate what is causing the slow down.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Tony Toews [MVP]]

I have a form with a series of unbound text boxes and list boxes and a few
buttons. What causes forms to mortally slow down? Whenever I call up the form
it takes forever to open. Also, if I switch from form view to design view, it
changes pretty quickly; but if I change from design to form view it takes
forever. What am I missing?

Do you have any tables linked to a non existent MDB even though you
aren't using those tables anywhere in your app?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/