Setting a Tables field value equal to the value generated from a text box

[McArthurGDM]

What I would like - is the ability to update a particular field value in a table based on an expression generated within a control source text box on a form.



I can't calculate the expression directly in the table since I am establishing relationships for it.

Can I do this?

[June7]

Why do you need to save this calculated data? Can you just calculate when needed?

Saving calculated data should be avoided. The calculated value can get 'out of sync' with the raw data.

Saving will require code - macro or VBA - in some event.