>I had a same problem.
>Problem is when you are using USE statement grid is loosing control source.
>What I have done is not, maybe, very elegant, but it works.
>
>First, I made an empty GrdTable.dbf, then I made a cursor (or view) with records I want to show in a grid and append it to GrdTable, which is shown in a grid and which have same structure as cursor (or view), of course.
>When I need to show a different set of data, I zap GrdTable.dbf table, make a new cursor (or requery for view) and append records to a GrdTable.dbf table again. Than I need just one more refresh for grid.
>
>I hope this will help.
>Sale
Yes, this is exactly right and I use the same approach. However, for parameterized views you can just requery a view, when parameter changes, and grid should preserve its formatting. So, no need to recreate view, just change its parameter and requery().
In addition, check FAQ section here for Vlad's FAQ: "Grid reconstruction and how to avoid it"
If it's not broken, fix it until it is.
My Blog