Open form speed vs Navigation speed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
Have you tried using a query rather than a Filter on the form? I think this
may improve the performance.
 
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!
 
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!
Click to expand...
 
Back
Top