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.
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"