>i execute a procedure which does a CREATE VIEW TO filename and then a SET VIEW TO filename. after the SET VIEW my grid is blank. i believe it does a create view because later it will close all the databases (have not executed that far into the logic yet).
>
>have read int ut to try the following, which i did:
>
> grid1.recordsurcetype = 0
> grid1.recordsource = ""
> set view to filename
> grid1.recordsourcetype = 1
> grid1.recordsource = "table1"
>
>the recordsource = "", immediately loses my column controlsource. and then the set view still blanks my table.
>
>any suggestions would be appreciated. also, why does everyone on ut suggest recordsource = "" ? it does not allow your grid to keep its column controlsource, text formats, etc.
>
>thanks - brenda

You have to restore not only Grid.Recordsource but also each Column.Controlsource programmatically. Setting recordsource="" prior to overrriding recordsource cursor will not harm, and actually it will save you from resetting also each Column.Width and ColumnOrder. Basically, it's one of ways to handle grid.
There is another way, which is relevant if your grid recordset is small enough. This case, youcan CREATE CURSOR and base your grid on this cursor permanently. When you recollect new recordset, you just ZAP grid cursor and APPEND FROM new recordset. Here, the only thing you should do is Grid.Refresh