Solved Why does this error 2185 happen?

[Gasman]

Well apparently the query supporting the form is huge and not well optimised. I did not look at it the despite the form being slow on my laptop. I just concentrated on that event only.

Now I am trying to work out how MS have created that split form when I cannot see any matching controls in the non datasheet part.

 

[MajP]

I would not do this with a sql backend obviously. But if this is access I have done this with 100k records and use the FAYT on more than one field, and it is still instantaneous. So for the average Access users, this is never a problem.