>I am trying to rfresh a Grid Column and cant get it to work. Scenarios as follows:
>
>1. I have a number of colums in a Grid
>2. When I go into each column, I want the whole Grid to change sequence and be ordered by the tag linked to the column
>(i.e. the sequence should change but I want to stay on the same record)
>
>I have following code in th GOTFOCUS.
>
>lnREC=RECNO()
>set order to MYTAG
>GOTO lnRec
>
>I then tried the following with no success :-
>this.parent.parent.refresh ---> Doesent work
>thisform.refresh ---> Doesent work
>
>
>Any help appreciated.
>
>Regards,
>
>Gerard
Gerard,
Following code from a custom header click that works :
WITH this.parent.parent
IF !empty(this.parent.myTextBox.tagname)
SET order to tag (this.parent.myTextBox.tagname) ;
in (.recordsource)
ELSE
SET order to 0 in (.recordsource)
ENDIF
lnTempCurrec = recno(.recordsource)
.refresh
IF between(lnTempCurrec,1,reccount(.recordsource))
GO nTempCurrec in (.recordsource)
ENDIF
ENDWITH
Here pls note that I also used a subclassed textbox (myTextBox) which holds its relevant tagname property. Yes, I know it's strange code :)
Cetin