I tried that too. This grid seems to refuse to return to the default sort order (SWDN ASC). All other sorts including SWDN DESC function correctly. I am having the same problem everywhere I've tried this method.

BUT...

I found a solution. It is a hybrid of the "RecordSource=SPACE(0)" and the 'Safe Select' methods. I create the cursor up front like in the 'Safe Select' method. This seems to eliminate the "Table not found" error (or whatever error that was) I was getting under the RecordSource=space(0) method. Then use the RecordSource = SPACE(0) method (plus using CAST to ensure field compliance with the created Cursor) to repopulate the grid. This eliminates the problem I'm now having with the 'Safe Select' method.

Thanks for the suggestions,

Richard



>>I left that information out. The curDisplay is being created in the load event. I've tried splitting the INSERT...SELECT out to what you have suggested plus including NOFILTER. Same problem. APPEND FROM ... Same problem.
>Try to select into different cursor and also comment out Resize and AutoFit