* Clear the RecordSource to keep grid from rebuilding its columns thisform.oGrid.RecordSource = "" * Get the data use (table) alias SHOWDATA * Restore the RecordSource so the grid can display it. thisform.oGrid.RecordSource = "SHOWDATA"IF the columns of the grid skip or reorder any columns in the alias, you need to save/restore them as well. For example, my grid class has the following methods:
*Save Column ControlSources local x dimension This.aColCtrlSrc[This.ColumnCount] for x = 1 to .ColumnCount This.aColCtrlSrc[x] = .Columns[x].ControlSource endfor This.cRecordSource = This.RecordSource This.RecordSource = "" *Restore Column ControlSource local x This.RecordSource = This.cRecordSource for x = 1 to This.ColumnCount This.Columns[x].ControlSource = This.aColCtrlSrc[x] endforHTH,