Hi Hugo,
to avoid reconstructing the grid with all the settings and so on, I prefer this approach:
select whatever from myTable ... into cursor tempCursor
lcCursor=myGrid.RecordSource
select (lcCorsor)
zap
append from tempCursor
>>Thanks Hillmar and Erick,
>>I did try the Into Cursor MyCursor but still had problem updating the grid. The query would run OK and fill the grid when I put it in the load of the form, but when I run the same select statement from a control, the grid inside disappeared.
>>
>>TIA
>
>Ron,
>
>I see you solved this, but, if you want to have the select from a control, when you re-run the select statement, you need to dis-engage the grid first:
>
>
>myGrid.RecordSource = ''
>select whatever from myTable ... into cursor myCursor
>myGrid.RecordSource = 'myCursor'
>