hi Will,

Thanks, that helps!

but the grid changed to dislpay first four fields instead of the specific four fields I've chosen.
I tried to use this code to set it back but cant work:

Thisform.MyGrid.column1.controlsource=mySource.requiredField

any idea?



>Jimi,
>
>This should do it.
>
>Copy local data....
>
>THIS.oGrid.RecordControlType = 0
>THIS.oGrid.RecordControl = ""
>THIS.oGrid.ColumnCount = 0
>THIS.oGrid.ColumnCount = -1
>THIS.oGrid.RecordControl = "c:\temp\MyCursor.dbf"
>
>The problem is the grid needs to reload the columns. If you have the Grid's ColumnCount=-1 it will add a column for every field found in the recordsource property. So the first time the grid loads the column's ControlSource property is set to the grid's recordsource + the field name ("MySource"+"."+"FieldName"). If the RecordSource or field names are different the column will not load. Whenever you change the recordsource of a grid at runtime you should set the ColumnCount = 0 so they will be reloaded by the grid.
>
>Will