General information
Category:
Forms & Form designer
>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only