>Otherwise, you could try using the "Create View (viewname) As [select statment]" command to create the view- but it'll be tougher to manager the control sources of your grids if you are constantly deleting and recreating the view definition.

Sorry Michael, I didn't express myself correctly.

The form is based on an existing view. What I'd like to be able to do is change the view's sql statement on the fly.

Thanks