Just put txtQty.Value*txtCost.Value in the controlsource for that column or if you can't do that, create a method with that code and call the method in the controlsource
>I have an invoice module with detail lines in a grid. I have a very basic need: I want the last column in the grid to reflect price * qty. Here's my latest attempt, all unsuccessful: I set the Grid.txtExtended.Value to be
>
>=txtQty.Value * txtCost.Value
>
>1. When I go into an existing invoice, none of the lines extend properly.
>
>2. When I get one of the lines to multiply out, ALL of the txtExtended.Value's change, not just the line that I am on.
>
>How do I accomplish this seemingly simple feat??
>
>TIA.
>
>John