>Hi Nadya
>
>It's a SWAG, but isn't this the same problem as when you close and reopen a grids recordsource?
>Have you once tried to detach the grids before changing the datasession and attach them afterwards again?
>
>No idea if it works, but I think it would be worth a try.
>
>Regards
>Markus
Hi Markus,
Just tried your idea, seems to work, but I just did : _screen.activeform.pf1.page1.grdJobs.RecordSource="Jobs", which is not enough, because columns in the grid have fields not corresponding to Jobs fields directly (in different order, etc.). Also there are 4 grids in this form...
So my question is: is it possible to save current status of the form (Grid and their column ControlSources and then restore them back). Perhaps I have to go the Stats object route instead.
If it's not broken, fix it until it is.
My Blog