>I read it again. What exactly did I miss?
>
>Sorry. I thought that Andy included some of what I had written in Chapter 6 of KiloFox but he hadn't:
>
>One way to avoid having the grid turn into a blank grey blob is to set its RecordSource to an empty string before running the SELECT and then resetting it afterward. Although this will work in the simplest of cases, it is not a solution we recommend. While it will keep your grid from losing its mind, the grid's columns still lose their ControlSources and any embedded controls.

To me, this is equal to losing one's mind :). Or identity, at least.

Safe select is the best way around it, and it actually takes just a couple of lines.