>>David,
>
>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

Your view should be parameterized on Vendor and you can create indexes (temporary) for all the fields you want to sort on. You will also need to make sure to call the Refresh of the grid specifically instead of just the form Refresh.