Jamie,

You don't have to CREATE VIEW more than once. This should work just fine:

Requery( "TempView" )
thisform.Refresh()


>I have a grid in a form with the record source as a view named 'TempView' and RecordSourceType as 1-Alias. Based on user selection a method is called which "Re"creates the view using Create SQL View TempView. I then do thisform.refresh. The view is recreated but the grid is not refreshed. I have also issued the command requery('tempview') but this is no help. I know the view is created because if I exit and reenter the form the most recently executed view is present. Any Assistance would be greatly appreciated....