Thanks for clarifying this. I forgot to mention that I also usually blank the control source of all columns before and reestablish them afterward.

---

>Be careful, I've encountered the following problem when clearing a control source in a grid ...
>
>All the control sources of the columns also get removed. Then when you reestablish the control source for the grid, the control sources of the columns will get reestablished with the fields from the table -- in the order that the fields appear in the table. So if the columns in your grid do not reflect the exact order of the table, you'll end up with a big headache!