Sometimes it seems that the controls have not updated their controlsource by the time this event fires. I have a grid where I want to validate that the 4 fields add up to zero but not all time it works.

Simplified code

PROCEDURE BeforeRowColChange 
LPARAMETERS nColIndex

ln_paid = payment + discount + writeoff
IF ln_paid > ac_arapl->balance
  =MESSAGEBOX('out of balance')
  NODEFAULT
ELSE
  =DODEFAULT(nColIndex)
ENDIF

When I trace though the table values are updated but if I let it run and debug out the ln_paid var it's like the last field I changed before I arrowed down into the next row isn't updated yet. I tried the FLUSH command but it didn't work either.