That's what I tried first, in fact. The problem is that when you click on the header, the focus of the grid gets changed somehow. So, the recno() when the click event starts is the new recno(), not the old one.
>Hi Todd,
>
>>Hmmm... I added a property to the form and then updated that propert in the grid's AfterRowColChange event. Then, in the click event of the header, I placed, go thisform.currec after the set order to statement.
>
>New Properties, AfterRowColChange? To much, try:
>
>
nRec = recno(grid.recordSource)
>set order to ....
>thisform.refresh()
>go nRec in (grid.RecordSource)
You will have to tweak this with paranthesis I think. Does this work?
--Todd Sherman
-Wake Up! Smell the Coffee!