Steve,

Although I'll vouch for the complete discombobulation of a grid when trying to change record sources, I find that it happens even if I've got a view as a record source. Very disconcerting and I'm trying to find the best manner of getting around it so that it's at least not so visible to the user. The worst part is that the grid definition is also out of whack and I've lost some custom control definitions that might have been in some of the columns.

Steve

>When you change a Grid's RecordSource this is what you get. In the time between disconnecting RecordSource 1 and conecting RecordSource 2 the grid gets all discombobulated and forgets all about itself.
>
>If the Grid id based on a view you don't get this sproblem... There are other ways that work too but, offhand, this is what I remember <s>.
>
>>---------------------------------------
>>I run a form, send a query to a grid and refresh. The first time through, the grid comes up with properties properly set. When I try to run the query again something resets all the grid properties to none or 0....