>Naomi,
>
>Won't resetting RecordSource to an empty string 'reset' all columns? Or is this necessary if the cursor fields do not all get involved with the grid's columns?
>
>The reason why I use CursorFill instead of CursorRefresh is because I reconstruct SelectCmd which needs CursorFill to 'take effect'.
>
>Thanks
>Dennis
>
Take a look at the FAQ by Vlad Grynchyshyn about how to avoid grid reconstruction. The second popular technique after safe select approach is to set the RecordSource to an empty string before re-building grid's record source. This technique preserves the columns (assuming the cursor's names are the same and columns are the same).
If it's not broken, fix it until it is.
My Blog