Question Best way around Write Conflict Error

[WineSnob]

I am getting a write conflict error when trying to update another field on the same record. What is the best way to work around this? I have a form in continuous forms that filters records by month. I would like to Update the field CF Income to equal Actual Income when I Change Actual Income. I have query an update query that will do this but and I put it on an afterUpdate event for the Actual Income (which gives me the error.... I understand that) Any suggestions for a work around?

 

[Beetle]

If CFIncome is to always be equal to ActualIncome then it probably shouldn't be a field in the table to begin with, just a calculated field in a query or a calculated expression in a form or report control, then you would never have to worry about making sure it gets updated.

Having said that, if it is a field in the same record source, then I'm not sure why you be trying to run an Update query. All you should need in the AfterUpdate event of ActualIncome is;

Me!CFIncome = Me!ActualIncome

 

[WineSnob]

Perfect and Simple...... I don't know why I didn't think of that