>>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?
>
>
>You could define these settings in code after the select...
>
>with thisform.grid1.
> .column1.width=100
> .column1.header1.caption='Whatever'
> .column2.width=300
>endwith

Hi Stacy

I did try this, but what a pain. When I changed the column size on the form, I forgot to change the code, then at runtime it "popped" back to the old values. Fred Taylor had a great suggestion that seems to work just fine! The suggestion was

> 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"

Thanks for your suggestion.