David,

My grid is based on remote views. I need to run queries because I end up crosstabbing to get the desired information. My fields are as follows (one example). Store Number, Name, State, Lastweek, thisweek, last year, prct_diff etc. Below is a quick look at my process.

1. Click the check box to re-sort the data (default view sorts by store)
2. List box display the various numeric fields to sort on (user makes selection)
3. Form displays the order (asc or desc)
4. Code runs Select * from grid1.recordsource order by listbox.value into cursor grid1.recordsource (I use the same name)

When run from the check box, everything always works perfectly, but when I run it from the grid header, it runs the first time and the second time I click the header It's as though there is no code at all.

Thanks again,

Scott