>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*
David,
Thanks for all your help. I owe you one.
Winn Pauley