the data has been changed another user edited this record
i have a main form and a subform to show the details.
in the main form there are two field i am looking.
One is a read only field named named MinorityContent.
other is text box to enter a percentage (%) named MinorityContentPercent.
I have an event in for that to multiply the above 2 fields and show in the read only field.
Private Sub MinorityContentPercent_AfterUpdate()
Dim MinorityContent As Currency
MinorityContent = some value from the subform using Dsum function.
Me!MinorityContent = MinorityContent * Me!MinorityContentPercent
Then in the subform if the user changed any number i need to repopulate the above read only filed named Me!MinorityContent.
To do that i have an event in the Form_afterupdate EVENT like this
Forms![Job Revision - form].Form![Job Revision - subform]!MinorityContent = MinorityContent * Forms![Job Revision - form].Form![Job Revision - subform]!MinorityContentPercent
where MinorityContent is a variable calculated (same as the one above).
Now my problem is that if i edit the minority content in the main form and then changed any thing in the subform and then edit the value in the subform i get a warning that the data has been changed another user edited this recordvalue and saved it error.
How can i avoid this error.(It is in my local machine -no one is editing it aother than me)