Delay or stop subform from requery

[SteveJtoo]

I have a form/form and subform Datasheet but the main data entry is done on the subform datasheet. The problem is that it keeps re-querying or refreshing in the middle of an entry which is not good because it comes back in a different line. Is there a way to stop or delay the subform requery some way.

 

[boblarson]

Sounds like you have some timer going. Do you?

 

[SteveJtoo]

No. There is no timer. I think it's just what Access does. It requeries about every 5 seconds.

 

[boblarson]

No. There is no timer. I think it's just what Access does. It requeries about every 5 seconds.

No, it doesn't do that as a normal thing. It may get data behind the scenes but it doesn't do it so as to interrupt data entry. Something else is going on here. Do you have any code in the subform's ON CURRENT event?