Hi Naomi,

ah, I had forgotten about Andy's method. Thanks for the memory. :)

Hank

>Hi Hank,
>
>I think the most recommended and simplest method is 'Safe Select'. You can Google for that expression.
>
>>Hi Tamar,
>>
>>I have a faint memory (like all the rest <s>) of you coming up with a neat trick, back in the day, for keeping the formatting of the grid while changing the recordsource. My memory is of setting the recordsource to chr(0), but I don't remember if there were other parts. Of course this could have been pre-VFP, back in the 2.6 days.
>>
>>Hank
>>
>>>>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