>There was an article in Fox Advisor about this several months ago. Basically you need to redefine the view in the DBC before you do the requery. You can build the view initially as...
>
>SELECT Fields FROM Tables WHERE .t.
>
>Then, build your select on the fly and recreate the view with the CREATE VIEW command. Of course, this will requre each user to have a private .DBC, but that is generally recomended anyway.
>
>BOb
What does this do to the view that is already open? Does the view get closed? when I issue the CREATE VIEW command?