>I have code to capture the record number in the BeforeRowColChange to a form property. In 9 of 12 column headers have code to set the order of the data to that field. At the end of the header code it goes to the record variable if it is not equal to the recno. Can anyone tell me why the record pointer jumps around?
>
>* BeforeRowColChange code
>ThisForm.pnRecord = RECNO()
>
>*End of header code
>WITH ThisForm
> IF RECNO() != .pnRecord
> GOTO .pnRecord
> ENDIF
>ENDWITH
>
>Thanks in advance, Chuck
It would be more reliable to keep pointer (recno()) in variable, before changing recordsource order, i.e. in the same header code, and then restore after SET ORDER. Grid.beforerowcolchange will not help here.
Edward Pikman
Independent Consultant