Grid Refreshing Loses Column Order

[Millard]

Please help. Once my grid refreshes, the columns changes
with heading from the alias table. However, I am only using
6 fields from a table which contains 20. When the grid refreshes it loses the original heading which I initially set. How can I lock in my original 6 columns and avoid
the grid columns changes after refreshing data?

 

[fluteplr]

set the recordsource property to null before refreshing the or cursor that the grid is attached to. Then set the recordsource back.

Or better yet attach the grid to a parameterized view and avoid the issue all together.

 

[Millard]

Thanks! It works!!!!