Scrolling

[Space Cowboy]

Good Afternoon Good People,

Some of my queries allow me to scroll nicely through the records.

Some are very "scratchy" and have a delayed action of a second or so. What causes this?

 

[Minty]

Frequently, it can be calls to either functions or DLookups(), also complicated calculations can slow down the "Live" view, as Access generally only does what it needs to do to display the first 30 or 40 rows of a query display.