Hi Marcia,

Your absolutely right. Setting the recordsource to '' is only necessary when actually closing the recordsource to which the grid is based on.

Thanks for clarifying.
John

>Hi John.
>
>>> The first thing to do before requerying the views is set the recordsource for the grid to ''. Then after the view has been requeried set the recordsource back to the view. <<
>
>This technique is only useful when you are restting the grid's recordSource. It is not necessary when the grid's RecordSource is a parameterized view.
>
>Marcia