I have a DBGrid bound to a recordset in a Data Enviroment. When I change the data in the recordset by issuing a new sql statement the data in the recordset changes but the grid still shows the old data.

I have tried setting the grid.datasource to nothing and then setting the grid.datasource to the data enviroment recordset but then nothing shows up in the grid. I've also tried using the grid.rebind and grid.refresh and nothing seems to work.

The only way I've got it to work is to close the form that has the grid on it and then reopen it. However, I want to keep the form open and the data in the grid would change with changes in the recordset.

Any suggestions?