For that you could use a CA, gather the data to some temporary cursor and refresh the CA from this cursor.
>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
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]