>I have a grid in which the RecordSourceType is "SQL Statement". I supply a RecordSource SQL string in the grids init. Can I change that RecordSource SQL sting at run time to something different? How do I get the grid to requery since it is not a view.
>
>Thanks
Greg,
You can just change the SQL string. But this preserves grid column formatting. If you want it to change also, before assigning new SQL string :
thisform.mygrid.columncount = -1
Refreshing grid is enough to "requery" it. If you have "where" in SQL then be sure fields used with "where" are indexed.
Cetin