>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
Low-carb diet not working? Try the Low-food diet instead!