Datagrid - Accessing Content of a Cell

I have a datagrid that has a datasource of an ado data control. The data control accesses a table in an Access database that is a list of names (REQUESTORNAMES).

On my form the datagrid is visible to the user, who can change one of the names if needed (i.e. if a name is spelled wrong). Once this change is made, I need to grab that new name and search another table (Workorders table) for every instance of that name and change it to the corrected name.

How do I go about getting access to that cell's contents? I have been playing with bookmark, but I am not making much headway. Does anyone have a suggestion?

Thanks much

The datagrid cells have some events that let you know when the user changes (or at least try) the data in a cell.

the event that is triggered after the data in a cell is changed Succesfully is : AfterColEdit

Is here where you code the search in other tables.

For more information about this event check the msdn.

Cheers

Jose Reyes