>Hi guys here is my problem
>
>I have an app, that opens a table thru getfile(), and a grid that
>shows the info , then afterwards displays only two columns from that
>table only, kinda like after process, this is what you got.. It works
>fine the first time, when It comes to the second table, say I want to
>check another table then loads up all the fields on the grid as usuall
>but when my process finish then the two columns does not show up, but the entire set of fields remains.. any way I can reset this grid and reuse it again..
>The RecordSource is set up to ALIAS()
>ColumnCount is set up at 2
>during design time.
>
>Any ideas on how to solve this
>
>thanks
>
>Mark Oliva

When you assign a recordsource to a grid, and then kill that recordsource while the grid is still 'attached' to it, the grid loses its mind and forgets everyhing you told it. To preserve grid settings when changing controlsources, set the grid's Recordsource to "" and then open your table and reassign the recordsource.