>>>Worked for me...
>>
>>I have no problem with the recno(), what I want to do is keep the same relati
>ve
>>row from one column to another
>>when the order changes between them.
>>
>>You were trying to keep the results as relative row # 1, I want to be able to
> p
>>ress the down arrow (to relative
>>row 2) then right arrow (to column 2, changing order of table) and still be i
>n
>>relative row 2.
>
>I was on row 8 (of 20), changed order, and I was on row 8 again, but
>quite a different record in row 8 (only the record in first row was the
>same as before). When I tried to watch in debugger what's going on, it
>worked OK, so I remembered someone here said that it has something to do
>with the grid's focus. So I tried to grid.setfocus right after changing
>order, and it worked: I remained in row 8 on the same record, and all
>the other rows had different records now. I've used form.activate
>instead just because I wanted to use this grid from other form's
>controls' valid events.
>
>I've probably put the Recno() just to be sure, before I got this to
>work. It's probably not necessary at all - I keep it for some other
>reasons (in case something is called from this grid, which may hop up
>and down along the table, I want to get back when it exits).
I use the control.SetFocus to refresh things. I'll try the Grid.SetFocus and see if that works better.
Bill
Bill Morris