Other than my math being off, it appears to be working now. My mistake was not in using the GotFocus, but using ProgrammaticChange to do the updates. That method wasn't firing at all.
Thanks
AGAIN for the help, all!
-- Gerry
>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
** Gerry White / Hagerstown, MD, USA --
** Developing since 1986 in Foxpro, VFP, Oracle, and Java.
**
http://GerrysPlace.com