>I have a custom function, "BeforeRowChange", called from BeforeRowColChange. When the row changes, I compare the values in the cursor that is the grid's recordsource against the values in the business object. If the values have changed, I update the BO.
>
>I noticed that "sometimes" changes weren't being recorded. I finally figured out what was happening. The recordsource isn't updated until after BeforeRowColChange runs. So if I change the value in a cell and go to another row without going to another column first, the recordsource isn't updated when my compare code runs and the BO doesn't get updated.
>
>Now that I understand what's happening, I need to know what to do about it. From BeforeRowColChange, is there any way to get at the value that was just entered without resorting to hard coding the path to the textbox and checking the value?
>
>Thanks,
>
>Michelle
AFAIK unfortunately you've to find correct control. Assuming column orders have not changed and textbox controls are default ones :
with this.Columns(nColIndex).Text1
.Value = .Value
endwith
Cetin