>Hi,
>
>I have a grid on my form and, in the BeforeRowColChange event I have the
>following:
>
>IF INLIST(nColIndex, 2, 4)
> REPLACE Total WITH Item * Cost
>ENDIF
>
>The strange thing is that, if I am trying to exit column 2 of the grid, the
>code works fine. If I'm exiting column 4, it doesn't do squat. If I tab
>through the rest of the fields so that I'm exiting column 2 again, it works
>fine again.
>
>(I know that I shouldn't have a field in a table that can be calculated
>from two other fields in the table but there are reasons why it has to be
>that way for now.)
>
>One thought I had is that nColIndex also counts the record marker (which is
>displayed) and deleted record (which is _not_ displayed) columns and that
>what I'm seeing is it working for column 4 with column 2 being hidden. IOW,
>I should be looking at 4 and 6 instead of 2 and 4. However, when I tested
>this idea, it didn't work either.
>
>Any idea what I'm doing wrong?
>
>
>Gary J. Sibio
Use Trace window to make sure that BeforeRowChange event fired (or not). It will help you to figure out where the problem is.
Edward Pikman
Independent Consultant