Is the formula the same for all 35 controls or each has a different formula?
>Yes, putting the formula in the refresh works, but there are 35 of them and I don't want to type all 35 formulas in the refresh method. I was hoping there was an easier way...
>
>
>>>If a control has nothing in the controlsource but has a formula for its value i.e. m.prem1+m.prem2 refreshing the control does not run the formula again. Is there anyway to refresh those controls without restating the value as in this.txtprem_tot.value=m.prem1+m.prem2?
>>>
>>>TIA,
>>>Tracy
>>
>>
>>If I understand you correctly, have you tried to put the formula in the Refresh method of the control? Seems to me it should work.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham