>In addition to Larry's reply check Mike Helland's FAQ here How do I add event code to Grid Controls built at run-time? October 24, 2000 14:31 FAQ #7967

Larry's solution is much better than using this method in this scenario. No reason to write the code in two places. Also, to add to Larry's idea, you should probably store the control source's of the columns before you nuke the recordsource, so you can restore them when yourestore the recordsource.