>I have a grid on a form, which services a number of files with exactly the same structure. Problem I am having is that I can't set the order programmatically. At the start the order is fine, but change the RecordSource, and try to set order, and nothing happens. I can put code in the header of a column, and physically click it, and then the order will change correctly, but if I click that header programmatically, it triggers the messagebox() I have there saying 'we are here!', but the code doesn't run. Click the header with the mouse, and it runs great. I am sure someone has battled this demon before. Thanks for your help!

The problem is that you're changing the RecordSource. That removes all customization of the grid.

To have code that persists when you change the RecordSource, it needs to be in the grid class, not the grid object.

Tamar