>>Another little "gotcha" with any method that relies on order is that the columns can become disordered unless they all have controlsources individually assigned. I.e., a user moves (drags-drops) column 3 to column 1. Then does a fresh query - the data may be out of order now, with the wrong header showing - depending on how your code works, and only if columns are movable. But it certainly can happen (been there, done it...)
>
>
>Thanks. I think there is a property that would keep the user from rearranging the columns. I'll check on that.

Whoops, hit send instead of preview - yes, it's the column Movable property - but you should try to leave that on if possible, it's a Windows standard, and helpful to users at times, particularly when there are many columns. It's fairly easy to make a custom method to re-assign column controlsources...