>Why a textbox.ControlSource do not accept an expression like a Column.ControlSource.
>
>Expl. ‘table1.prise1 – table1.prise2’ or ‘UPPER(table1.name)’ is accepted in a column.ControlSource bat not with a textbox.ControlSource.
>
>When I try this with a textbox.ControlSource the ERROR 1742 occur.
>Maybe somebody encountered the same problem and now why textbox.ControlSource do not accept this and has a solution for this problem.
>
>Tanks
When you put that to a column it's a calculated "value". So for textbox leave controlsource empty and set "value". You could do something like :
* prise1 and prise2.textbox.lostfocus
thisform.mytextbox.value = table1.prise1 – table1.prise2
* no need to refresh
Cetin