>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
Try putting your exspression in the value, instead of the control source. Control source can only be one thing.
HTH
Jeff
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com