Unable to get a formula result to setvalue in the table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jimbo213 - 15 May 2008 14:55 GMT

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 !!!

Signature

Thanks for your reply & assistance.
Jimbo213

Reply to this Message

Klatuu - 15 May 2008 16:08 GMT

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.

Signature

Dave Hargis, Microsoft Access MVP

> I have this wonderful formula in a text box that displays just fine on the
> form.
[quoted text clipped - 14 lines]
> I've tried searching this forum and others with little guidance.
> I feel like such a dope !!!

Reply to this Message

KARL DEWEY - 15 May 2008 16:09 GMT

Bind the textbox to the field in the table.

Signature

KARL DEWEY
Build a little - Test a little

Reply to this Message