>>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.

Then the answer is most likely NO. Even if you use macro substitution, the macro value is only evaluated when the view is created. (i wouldn't reccommend trying double macro substitution unless you're a complete masochist)

You can create and remove views programmatically, but anything linked to the view would have to be programmatically re-linked to the new view. (there might be workarounds/tricks to prevent that though)

You might want to consider an alternative strategy.