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*