>I wish to populate a grid with either a table or SQL depending upon a user selection. I have added the necessary code into the "init" event of the grid:
>
>for table data grid.recordsourcetype = 0
>for SQL data grid.recordsourcetype = 4
>
>On the properties of the grid I have selected 0 (table)
>
>However, The grid always defaults to 0 Table.
>
>My question:
>
>Does the setting in the properties always overide teh settings in the code?
>
>Thanks
>
>Brendan

No. First set type then recordsource. If selection is on same form grid would bind itself to first alias it finds if no recordsource is given.
Cetin