Unable to get a formula result to setvalue in the table

  • Thread starter Thread starter Jimbo213
  • Start date Start date
J

Jimbo213

I have this wonderful formula in a text box that displays just fine on the
form.
Every time a radio-button in one of seven frames is pushed, the value
recalculates.

Problem: I can't get the resulting value to be entered in the underlying
table


Here is the formula for Status_Score.setvalue

=([StatusResultEIA]+[StatusResultData]+([StatusResultFIT]*[Status_FIT_Mult])+([StatusResultWave]*[Status_WAVE_Mult])+([Status_PERF_Mult]*[StatusResultPerf])+[StatusResultEnv]+[StatusResultImpl])/[Status_Count]*25/100

I have tried creating a macro behind each frame.afterupdate - no good
I tried creating a code behind each frame.afterupdate - no good

What will work?
I've tried searching this forum and others with little guidance.
I feel like such a dope !!!
 
If your formula is in the text box Control Source property, then it will not
update the table. The control source for the text box should be the name of
the field where you want the results of the formula.

Now, where to run the formula depends on when you want it applied. If it
will be for only new records, then you can use the control's Default Value
property. If it needs to apply to existing records, then there is still the
problem of the other controls affecting it's value. Not knowing enough about
how your form operates, I can't give an exact answer.
 
Back
Top