>I have a grid where I have set the ControlSource of each column to a field that exists in a custom SQL query, then I run over and over in the form.
>
>So, you know the routine...
>
>oGrid.RecordSource=''
>Select blah,blah,blah from somealias where sometest Into Cursor csrResults
>oGrid.RecordSource='csrResults'
>
>Now the query returns many columns, but I only display certain ones the grid.
>
>So, what is the trick to make the ControlSource setting for each column survive (persist) when the RecordSource of the grid is changed like this. I'm sure I could just write some code that will reinstate it on each column...
>
>oGrid.Column1.RecordSource = 'csrResults.Qty'
>oGrid.Column2.RecordSource = 'csrResults.Length'
>etc.
>
>
>Does it have to be that ugly of a hands-on approach?
The simplest and well-known/discussed approach is presented in this blog
Safe Select to preserve your grid
If it's not broken, fix it until it is.
My Blog