>
1. Add a "Change sort order" button on my form.
>
>2. This button will call a form with your "sort grid" on it that shows the columns from my underlying form
>
>3. Let the user move things (the column names) around to their liking, then click on a Sort Now button.
>
>4. The Sort Now button reorders the recordsource on my original form to match the order set by the user.
>
>Did I finally get it right?>
>LOL!!! Yes, more or less. I probably should have explained it a little better. The way that I do it is that I have the sort order grid on the same form that contains the grid that I am sorting. But you could just as easily do it with a popup form. Just holler if you nave any more questions.
Thanks Marcia!