>>>Correct me if I'm wrong here, but when using an SQL statment as the record source the grid *totally ignores* the control source...so they are a non-issue. With recordsourcetype = 4 you must structure the SELECT statement to put the fields in the order of the grid columns. Grids with SQL record source types are my primary tool for lookup routines, and I've never had to refresh one for it to trigger...I simply change the recordsource, normally via a method that fires from the interactive change event of one or more text boxes (or check boxes or combos or option groups).
>>
>>Yes, it works in simple cases when column.controlsource is always field, but try to resize some columns and/or change column position in run-time and then 'refresh' the grid. It will return to previous state, that might be a reason for user's complaints.
>
>Interesting, Ed...I never tried that. But if the grids recordsource type is 4-SQL, what would be the workaround because the control source is ignored anyway in type 4?
I have grave suspicion that there is no workaround here, this is why I never use type 4, and use 1-cursor's alias.
Edward Pikman
Independent Consultant