I want to use a drop-down box to change the order of items in a view displayed in a grid on a form, but there is no index file for the view and I am not sure how to create one.

I don't see a way to put a parameter in the order by section of the views sql statement.

Is it possible to dynamically do this? If so, how?