>>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
>
>You should issue:
>Grid.Recordsource=""
>Grid.Recordsource=cMynewsqlstring
>Grid.Refresh
All I do is issue Grid.Recordsource=cMynewsqlstring and the grid is smart enough to do the rest :)