>>If somebody has a nice synopsis of how to make
>>grids behave
>>(i.e., maintain their column widths, headings,
>>etc), I would sure
>>like for them to post it.
>
>Hi Mark,
>
>The workaround i've found to prevent a grid from
>losing it's design properties when the
>recordsource is changed programatically, is
>reseting first the recordsource property:
>
>* Always before changing recordsource on a grid
>THISFORM.MyGrid.RecordSource = ""
>* Then assign your new source of data.
>* If you have a SQL-Query into Cursor that changes
>the content
>* of the data in the grid, no matter if (the
>cursor) have the
>* same name it has before, here is where to place
>it. (After * reseting Recordsource)
>THISFORM.MyGrid.RecordSource = "MySource"
>* And refresh it
>THISFORM.MyGrid.Refresh()
>
>HTH,
>J. Luis
Thanks Jose
Was trying to get that to him but was too lazy to find it & paste it...
Tom