I’m using a textbox class as the currentcontrol of a grid’s column.
The when event of the textbox stores the value of its recourdsource into a property (OldValue) in order to detect changes at the valid event by comparing both values, the recordsource new value (if changed) and the property value (OldValue).

lcRecordSource = this.ControlSource
this.OldValue = evaluate(lcRecordSource)

This seems to be working fine when changing from row to row but when accesing another column and returning back to the previous column (like when hitting Right arrow-Left arrow), the When event is getting a zero as the controlsource value.

It seems like if the controlsource value has not been updated yet internally when the When event is fired.

Any hints about what to do and/or any other ways arround to track changes are appreciated.

Regards and thanks in advance.

Oscar Corte