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."
"Ray S." <RayS[ at ]discussions.microsoft.com> wrote in message
news:6FD12FA7-1E79-411E-88F4-DBE0CEEFF306[ at ]microsoft.com...
[Quoted Text] >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?
|