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