>>Hi!
>>
>>How to re-generate (re poblate) a Grid that use a cursor previously?...
>>
>>When trying to repoblate Grid (with the regenerated cursor) , it Grid loose the columns references...
>>
>>Thanks in advance
>>Carlos Burgos
>
>Carlos,
>There are several ways:
>1. Redefine whole your grid AFTER your second select:
>
>thisform.Grid1.RecordSource = NULL
>SELECT ....
> INTO CURSOR Test READWRITE
>thisform.Grid1.RecordSource = [Test]
>thisform.Grid1.Colum1.ControlSource - [Test.Field1]
>....
>
>
>2. Create a cursor, bind the grid on it and when you need to change the data just ZAP it and then select the records in it:
>
>SELECT MyGridCursor
>ZAP
>INSERT INTO MyGridCursor;
>SELECT ......
>
>
>3. use CursorAdapter with dynamic WHERE clause and just CursorRefresh() it :-)
I vote for the number 3 :) and 2.
If it's not broken, fix it until it is.
My Blog