Yeah, but I figured since you said this was not working, I would point you to the LostFocus. Did you get this to work. I do something similar in an Invoice grid using Got/LostFocus and it works for me.
>Actually, I had similar code in the
VALID for the applicable cell. I
ASSumed it might be more efficient for it to be updated only when the user changed something, which is what VALID's are for, right?
>
>- Gerry
>
>>>I did. Here's the code from txtDebit.GotFocus :
>>>
>>>THISFORM.OrigDebit = THIS.VALUE
>>>
>>>- Gerry
>>
>>Now the code in LostFocus? Depending on Debit or Credit column:
>>local lnDiff
>>lnDiff = This.Value - ThisForm.OrigDebit_or_Credit
>>if lnDiff <> 0
>> ThisForm.txtRunningTotal.Value = ThisForm.txtRunningTotal.Value <b>+ or -</b> lnDiff
>>endif
Mark McCasland
Midlothian, TX USA