can't get last userinput from datagrid

I can't get the input of the users when they edit a field in the datagrid.

In the event 'beforeColUpdate' I want to check the value they entered, but I always get the value that was already in the grid.

This is what I already used:

Code:

---

Debug.Print DataGrid1.Text
    Debug.Print DataGrid1.Columns(ColIndex).Text
    Debug.Print DataGrid1.Columns(ColIndex).Value
    Debug.Print DataGrid1.Columns(ColIndex).CellText(DataGrid1.Bookmark)
    Debug.Print DataGrid1.Columns(ColIndex).CellValue(DataGrid1.Bookmark)

---

How can I get the text the user just typed???

Does the edited record cause a new record to be created? If so, you might need to check the value in the BeforeInserted event...