'Another user changing data' error?

[Gkirkup]

I have a fairly standard sales entry setup - a form with entry of the sales header detail, and a subform (multiple lines) with line by line sales detail.
I sometimes (not always) get an error when completing the first sale detail line and moving to the second (blank) line: 'The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.'
There is definitely no other user on the system when I am doing this. I have seen this error in other places, but have never been able to correct it. Does anyone know what might cause this?

Robert

 

[boblarson]

How are you updating the main and subforms? Are they just bound forms linked together or are you running any SQL updates somewhere?

 

[Gkirkup]

Bob: They are just bound forms linked together. The only slightly unusual aspect is that 'on current' on the sale detail subform lines causes a requery of three other subforms, each driven by a query.

Robert

 

[boblarson]

Bob: They are just bound forms linked together. The only slightly unusual aspect is that 'on current' on the sale detail subform lines causes a requery of three other subforms, each driven by a query.

Robert

That could cause the problem. Make sure to save the record before requerying.