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