>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
Hi Gerard,
Have you tried setting the RecordSource of the Grid first to an empty string and then reassigning the table to the RecordSource so the grid rereads the table?
ThisForm.myGrid.RecordSource = ""
ThisForm.myGrid.RecordSource = MyTable
Mike
Michael P. Antonovich, MCSD
Email: mike@micmin.com
MicMin Associates - Orlando, FL