Open form speed vs Navigation speed

P

Plumdodge

All,
I am hitting a brick wall. One of my forms is quite slow to move from one
record to the next. I have gone through and refined the code surronding the
controls and it has improved dramitically. What I can't seem to fix though
is when I open the form via DoCmd.OpenForm Filter = XXX it is still very
slow? The criteria I am using is quite complex, but onces it is open
shouldn't be faster because it has loaded all the records? When I just open
the from unfiltered it is operating at the speed I'd prefer. Any ideas?
Thanks,
 
K

Klatuu

Have you tried using a query rather than a Filter on the form? I think this
may improve the performance.
 
P

Plumdodge

Klatuu,

Thank you very much, This made a world of difference and you have made me a
lot more popular the end users. Thanks a ton man!
 
K

Klatuu

Glad to help

Plumdodge said:
Klatuu,

Thank you very much, This made a world of difference and you have made me a
lot more popular the end users. Thanks a ton man!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top