>>>I am using a SQL - Select into a cursor which is used as the datasource for my grid. I use the following line after the select and it updates fine the first time through.
>>
>>>THISFORM.ComboBox1.RowSource = THISFORM.ComboBox1.RowSource
>>
>>>However, when the select is executed the second, or third, or.... time the headings and colum widths are reset to match the cursor. How do I maintain my original settings?
>>
>>Well, I don't know if there is a better way, but I manually set the WIDTH and HEADER for each column in the grid. It works for now!
>
>Have you tried setting the RecordSource to an empty string ("") before you reset the cursor.
>
>thisform.oGrid.RecordSource = ""
>*re query you cursor
>thisform.oGrid.RecordSource = "cursoralias"
That works! Thanks!
____________________________________________
Norm Peterson
It's a dog eat dog world out there,
and I'm wear'n milk bone underware!