Hi!

ActivateCell, ActiveRow, ActiveCol, RelativeRow, RelativeCol properties are not reliable.
To activate a particular cell, set the record pointer in the record source to the appropriate record, than issue Column.SetFocus.

HTH.

>To all,
>
> I have a grid that is populated by three fields in a local view. Two of the fields affect the sort order and as they are changed, the data needs to be resorted. On the valid for the text box, I update the file and issue a requery. The data comes back in the correct order and I issue grdWhatever.ActivateCell(liRow,liColumn) with the row that it's need to be on. I checked with a wait window that the row and column the grid is supposed to be on is correct, but the grid stays on the same row as the changed data was on. The funny thing is, if I Trace through it, everything works fine and the correct row is selected.
>
> Any help would be appreciated.
>
>John Rowlinson
>Microworks POS Solutions