If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Unable to get a formula result to setvalue in the table
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 !!! -- Thanks for your reply & assistance. Jimbo213 |
#2
|
|||
|
|||
Unable to get a formula result to setvalue in the table
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. -- Dave Hargis, Microsoft Access MVP "Jimbo213" wrote: 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 !!! -- Thanks for your reply & assistance. Jimbo213 |
#3
|
|||
|
|||
Unable to get a formula result to setvalue in the table
Bind the textbox to the field in the table.
-- KARL DEWEY Build a little - Test a little "Jimbo213" wrote: 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 !!! -- Thanks for your reply & assistance. Jimbo213 |
Thread Tools | |
Display Modes | |
|
|