>>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.
Ok, thanks. I was thinking about constructing grid in run-time, where your solution seems to be the best one. In this particular problem, I agree, no need to complicate your life, if code is already written in design time.
If it's not broken, fix it until it is.
My Blog