WITH thisform.GrdFloor .columncount = 16 .recordsource = "tmpfloor" .column1.controlsource = "tmpfloor.fn_room" .column2.ComboCeiling.ColumnCount = 1 .column2.ComboCeiling.ColumnWidths = "120" .column2.ComboCeiling.ColumnLines = .t. .column2.ComboCeiling.DisplayCount = 6 .column2.ComboCeiling.rowsourcetype = 3 && - SQL Statement .column2.ComboCeiling.rowsource = "SELECT floortype FROM floo...." .column1.width = 120 .column1.fontsize = 8 .column1.readonly = .f. .column1.enabled = .t. .column1.movable = .f. .column1.resizable = .f. .column1.header1.caption = "Room" ENDWITH>I've done the following since VFP7 and it has always worked. Now it sometimes doesn't. The error I'm getting is that the first column doesn't exist where prior to the RecordSource being set to '' it did.
>this.Recordsource = '' >{Execute sql statement here} >this.RecordSource = 'MyCursor' > >{reset Controlsources for Columns} >this.Refresh() >>