It sounds like you should really be using views. Someday, I'll get around to them myself. But for now, zapping the Grids.RecordSource property works for >me. We built code into our base grid that saves/restores the column stuff. And now with Access/Assign, it's all "behind-the-scenes".

Yes, like views myself and maybe more appropriate, but I think there is one downer with views. When the structure of an involved table(s) change, you must virtually recreat the views, and if it's a complex view it can be disheartening.