Hi Larry

Why are you recreating the view? Just change its parameters and requery. Recreating the view will force you to reassign the grid's controlsource etc.

HTH
>Hi -
>
>I have created a view which is being displayed in a readonly grid. I then have a button which forces a the view to be recreated (CREATE SQL VIEW), I then perform a Requery. Hoping that the the grid will be refreshed with the new view data. Its not.Why please?
>
>If I close the view then open it again it shows the new data there. I also checked the requery() return value, it is 1, so everything is working correctly just the refreshed data is not updating the active view. Can someone please advise.
>
>Thanks,
>
>Larry