I have created a split view form to provide a summary of outstanding activities. On the top half of the screen, all the variables for the currently selected record are displayed.
Also at the top is a combo box that allows the user to choose a desired filter option that applies a filter and tries to display selected columns in the desired order in the datasheet view list on the bottom half of the form. Different users only want certain variables to appear in the datasheet in their desired order so I am using the Visible and ColumnOrder properties to achieve this.
What I am finding strange is that it is not always working reliably. E.g. In one instance I set columnorders in one sequence and they worked fine and then I simply reversed the columnorder and one of the fields won't display.
Does anyone know if there is anything I need to look out for that could be causing this issue?