write conflict in access project

[Guest]

I have main form(Orders) and a linked subform(Order Details). I have to
update a Total Discount field on Main form after any changes to Details
Discount field on any line in subform. As soon as I move a Focus to main
form, I get Write conflict message. The Discount field on main form is a
bound field.

It works fine when I use mdb as front end and mdb or SQL server as backend,
but if I use ADP as front end, I get this error messsage

Any ideas?
Thanks

 

[Rob Oldfield]

Is Total Discount on the main form bound or unbound? How are you updating
it?

 

[Guest]

Yes, it is a bound control

me.parent!TotalDiscount=me.txtCalcDiscount

where txtCalcDiscount a hidden field on subform that holds up to date
average discount from subform

 

[Rob Oldfield]

You mean that TotalDiscount is bound to a table field? If so then that
would be your problem I think, attempting to update it because it's linked
to the table field, and also to the sum of the field on the subtable.

Are you storing it at the main table level?