Jamie, I didn't catch the beginning of this, so forgive me if I'm restating what's been said, but have you looked at parameterized views instead of recreating the view every time?

Alan

>I tried the Requery() and Refresh - No luck...
>
>The reason I'm using the create view more than once is so the user may select different options. i.e. Select records from specific vendor, Sort by Client Name, etc. When I issue a Create SQL View a second time, does it simply overwrite the first view? Do I need to delete it, close it, etc? Any other ideas... Thanks again.
>
>Jamie