Question Slow datasheet view / split form

[kLAcK]

Hi I have a database i have been working on (access 2007). In the past I have been using a list box to select records. Now I would like to use the datasheet view or split form view. Everything seemed fine until I moved to linked tables.

My problem is, with the same query, the listbox is lightning fast at changing the recordsource.

When I change the recordsource on a datasheet view or split form, it takes... ages and shows "Calculating.." On larger recordsets it freezes access.

Any advice?

 

[kLAcK]

Any ideas? I'm racking my brain with this one.

 

[kLAcK]

Ok i believe I found the problem, and it is bizzare.

I was using a split form, but hiding the form detail using the split view bar, by dragging the horizontal bar. I now resized it so that a tiny bit of the form detail is showing and... it now works!

I don't know why this would cause a problem. I am able to reproduce it over and over.

 

[Pat Hartman]

Thanks for reporting back. This is certainly a strange error. I don't use split forms because I know how to create the effect manually. The only advantage the "split form" has over the old fashioned way is the split view bar which I see by your post has issues.