>I type some text in a Column (say ControlSource=FirstName) and the use the arrow key to move to the next record. This is trapped in the BeforeRowColumnChange event where I issue a command WAIT WINDOW FirstName.
>However my recent changes are not shown. ie the changes do not get committed till I actually move to the next row or column.
>How can I overcome this problem?

with .columns(nIndex).Text1
.Value = .Value
endwith

However be warned above code assumes you haven't changed column orders + column current control is still default text1. For other cases you need to tweak it a little bit.
Cetin