I follow the same steps as Neil. I create a form method that configures the grid (usually called something like refreshgrid) and whenever I need to wipe out the data and reload, I call the form method.
>Hi all
>That's a classic grid recordsource question, and i know i have this fixed somewhere, but i gave up finding the code...
>I need to set a cursor as recordsource of a grid. The grid is formatted ( different backcolors for columns, bold font in some places etc... ).
>If i run:
>select .... into cursor myCursor
>thisform.myGrid.RecordSource="myCursor"
>the grid looses all the formatting. Also, should i set each column's controlsource everytime i recreate the cursor?
>
>Thanks
>Jaime
.·*´¨)
.·`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"