>>>How do you differentiate between a row or column change in a grid. RowColumnChange is just sent a number so it could be either one. I'm trying to stop a row change when the user has modified a record. Thanks.
>>
>>In BeforeRowColChange Event:
>>select gridsource && table/cursor/view
>>thisform.togglegrid=recno()
>>In AfterRowColChange Event:
>>select gridsource
>>IF thisform.togglegrid=recno()
>>**** row changed
>>ELSE
>>**** column changed
>>ENDIF
>
>recno() is very tricky, would avoid as can give erratic behavior, especially in multiuser environment with additions and deletions, packs and buffering etc. Much better to use activerow or a primary key field check.
Sorry, I have to mention that in multi-user environment RECNO() is pretty reliable because nobody can pack tables over there.
Edward Pikman
Independent Consultant