Hi!

When grid refreshed, the Value property of non-current column text box (or other control) is updted for each row, so you will have there whatever is in last refreshed row. Use another approach:

This.Parent.Parent.Column3.Text1.value =;
evaluate(This.Parent.Parent.Column1.Text1.ControlSource * This.Value).

It is recommended to work with current record fields instead of control properties in the grid.

>Can someone explain why the following will not give you the information expected.
>
>Example: A grid with 3 columns, one uses the down arrow to advance from row to row in column2 and as a value is entered in Column2 the following calculation is made for column3
>
>This.Parent.Parent.Column3.Text1.value =;
> This.Parent.Parent.Column1.Text1.Value * This.Value
>
>will not work unless the command:
>This.Parent.Parent.Column1.Text1.Refresh() is issued before the above command.
>
>Thanks in advance.