Update Table from IIf Calculated Form Field

[xyba]

I have a form (fmERA) which is bound to tblData. In the form I have textbox (txtCentreCalc) which contains an IIf statement.

What I am trying to do is update the calculated value of txtCentreCalc into a field (Centre) of tblData but I'm unsure how to do this.

Any help appreciated.

 

[Minty]

If you can always calculate it, you wouldn't normally store it, as it means trying to capture all possible updates of the source values to then update your result field.

 

[CJ_London]

You can do it with vba but agree with minty , don’t store calculated values in tables, calculate when required

 

[xyba]

OK, thanks guys.