Winn,

>I switched over to the view and it works. I was just wondering if there is a way to put the RECNO() from the view into the grid? I have tried every thing.

Good, now that your grid isn't self destructing things should go better. *s*

You will probably have to create a view based on the original view...

create sql view NewView select recno() as recnum, * from TheOriginalView

point your grid at NewView

when ever your parameter changes:

Requery( "TheOriginalView" )
Requery( "NewView" )
thisform.grdSeeTheView.Refresh()

* Warning: this is untested code off the top of my head *s*