>The easiest way to do this is to define a parameterized view and use that as the RecordSource for your grid. Thn,
> when you have to change the grid's contents, you just Requery() the view with a different paramter.

> Another technique that I use is what I call a "safe" select. I define an updateable cursor in the form load and use that
> as the RecordSource of the grid. Then, when I want to requery the grid's contents, I zap it's RecordSource, do a
> SELECT into a temporary cursor, and append from the temporary cursor into the grid's RecordSource. Zapping the
> grid's RecordSource will not reset the grid because it does not close the RecordSource.

if you're not going to use the parameterized view, but want to get result from a query try another method:
thisform.grid1.recordsource = []
... select statement-into ....
thisform.grid1.recordsource = "cursor"