I have a grid on a form that displays data from a view. When the user wants to look up a different set of data I delete the view and recreate it with the new data.

The problem is when I close the view, with USE, the grid names and columns disapear.

When The new view is created, based on the same name, the grid is still empty. I have even tried to rename the properties of the grid with the new view and the only thing I get are the column names and no data, eventhough I reset the controlsource properties.

I use refresh, and I still get no data. How can I refresh this grid?