>Pressing 'delete' is what got me into this mess :), along with the stupid wizard of course.
>
>I just can't figure out why the controlSource on each column is being ignored completely (see original post).
>
>Thanks for all of the input,
>
>steve
Steve,
If not in code then I suspect grid cannot find its recordsource thus populate from table-cursor in active workarea. It would be the case if you set Recordsource=(none) after builder sets it too. It behaves with a hierarchy that a recordsource must exist in order to controlsources have assignments and controls of columns' inherit from column.controlsources.
Just use the builder and add-delete your columns to your taste. Then you might simply remove builder added table from your DE. BUT do not change recordsource property. Controlsources would go mad as you do and set to (none). Also be sure recordsource alias and any controlsources that you refer to exists before grid.init fires (typically form.load - though you might set later in code anywhere and use designed grid as a template). Otherwise what you get is generally a blank grid.
with thisform.myGrid
.ColumnCount = -1
.RecordSource = 'mytable'
endwith
with thisform.myGrid
.RecordSource = 'mytable'
endwith
with thisform.myGrid
.RecordSource = ''
.RecordSource = 'mytable'
endwith
Cetin