Hi Gaylen.

It is a parameterized view. In the load event I set up some dummy variable for the view and open the view. I then reset the variables based on the parameters I send over from the calling program, so I only see the records which meet the criteria from the calling program.

You can USE the view NODATA. As long as you do this in the form's load or in the form's DE, you can still specify the view as the grid's RecordSource in the property sheet of the form designer. Then, in the form's Init(), you just REQUERY() the view based on the parameters you receive from the calling form.

This will not close the view, thereby resetting the grid.