Thanks Alan,
This is the option I went with and it works great! I always forget about the tag property and seldom use it.
Tracy
>>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
>
>Tracy, put the formula in the control tag. Then in the control refresh():
>
>
This.Value = EVALUATE(this.tag)
>
>Alan
.·*´¨)
.·`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"