>Hello Tore
>
>I use the controlsource like i say because :
>>I must change the controlsource because it´s the unique way to show me the calculate value on my grid.
>
>like i say , if i change the controlsource of my column that was the field "FI.U_VALHUM"
>when i save my invoice, this column on my table was empty, why ? it´s because i use the table field controlsource to show me a calculate value and when iám saving my invoice nothing is save in the field "FI.U_VALHUM".
>this calculation is "virtual" on my grid.
>I must without changing the controlsource make the calculation on this column after changing the value of another one, in this case my table field keep the calculate value.
>
>i hope you understand what i mean.
>Thanks
>Luis Santos
No, to be honest I don't understand why you can not set the controlsource directly. I use calculated columns in grids a lot. In the controlsource, try
((0+fi.u_nospeso-fi.u_VLDscemb)*fi.u_hum)/100