Formula in a text box

[fosdog]

I have a formula in a text box, but the resulting value does not get saved into the corresponding table. Any thoughts?

[FishVal]

I have a formula in a text box, but the resulting value does not get saved into the corresponding table. Any thoughts?

Thought #1
Calculated form control could not be bound to table because it is bound to formula.

Thought #2
Why it has to be saved in a table. I mean is it impossible to retrieve it later with a query using calculated field with the same formula?

Thought #3
If you anyway want to save to a table you should take special care about this. One of the way is to write VBA function which performs the same calculation as your formula does and saves the result to a table (e.g. via updating auxilary invisible textbox bound to the corresponding table field and put this function to your calculated textbox ControlSource.

Thought #4
The above is quite enough for the first time. :)