>>John,
>>
>>Hang in there. ..
>>
>>>
>>> I am working in the detail area of an invoice module. I have three tables
>>> I am working with: InvHead, InvDetail, and Inventory. InvHead is related
>>> to InvDetail by InvNo; InvDetail is related to Inventory by PartNo. (Sound
>>> familiar??) The invoice head to invoice detail is working OK, but I can't
>>> get the part # to behave:
>>>
>Miles and Barbara:
>
>Thank both of you VERY MUCH for your insights and suggestions. I now have the invoice detail behaving thanks to you two. EXCEPT: I can't do something as simple as get the Extended column to work. All I want to do is
> txtExtended.Value = txtQty.Value * txtCost.Value
>However, when I get one line of detail to multiply and Refresh, every txtExtended.Value changes to the new Value, not just the one line I am on. AND, if I arrow up and down the txtQty or txtCost columns of an invoice, lots of strange things happen. Doesn't the pointer in the table move as I move up and down in a grid?? There is something basic about grids that I am missing. This was all so easy to do in DOS . . . .
>
>Again, my sincere appreciation to both of you. Sorry to be such a pest!
>
>John
John, one of the earlier messages covered putting your code into the ControlSource. Check your setting for SPARSE in the column with the calculated value. I think it should be TRUE. NOT the default value, anyway, the opposite. This allows different rows to show the calculated data correctly.
HTH
Barbara