Hi Jamie,

Note Steve's comment at the end, you have to refresh the grid specifically - like this: thisform.grid1.refresh().
If you're using pages or formsets, you'll need to drill down to the grid accordingly...

Diana

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