>Is there any other way??
>Is this considered as a BUG???
>
>What really causes this behaviour??? is cursor or table have to do with it.

Anytime the .RecordSource of a grid is closed (table or cursor) the grid loses these properties. I know this behaviour has been around since VFP 5, but don't know about before then. Hopefully, it won't be around forever...

In the meantime, one work-around you can use is to create a class out of the grid and .RemoveObject() then .AddObject() every time you have to close the .RecordSource.