>Edward,
>
>Thanks for the reply. However, I'm not using any indexes because the views are coming from Sybase. I'm also not using the SORT command. My check box works like this:
>
>1. Click the Check Box (Changes value to 1)
>2. Activate (make visible) a list box display all the numeric fields.
> (i.e. LastYear, thisyear, Prct_diff etc..)
>3. Pop up new form asking for the sorting order (Asc or Desc)
>4. Select * from (grid1.recordsource) into grid1.recordsource
>
>When its run from the Check Box, everything always works perfectly, but when I run it from the header it only works once.
>
>Thanks Again,
>
>Scott
Your code overrides grid recordsource, it might be a reason. IMO, the safer way is to index view (you can do it on fly) and then just SET ORDER TO TAG ... ASCENDING/DESCENDING in Header.Click event.
Edward Pikman
Independent Consultant