I will be very interested in your solution. Creating grids via code has been a problem for me too as you cannot modify certain properties via code when they are created dynamically (the header or click methods are examples of this). I have stuck to creating grids the gui way on the form and then when I want to change the grid's source, setting the record source to "" first and then setting it to the valid new source (idea from Sergey).
I will be watching this thread to see what new ideas you are provided!
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"