I have a grid with a view as record source. I set the recordsource in the init of the form by code. I also set each column and field to a control source in the view using the properties control at design time. The grid disregard the control source field setting and displays the column in the order of the fields in the view. I know I can create another view with the fields in the same order as the columns I want displayed, but I use that same view for another grid which has a different set of columns that are displayed.

Any help would be appreciated.


Thanks
Gaylen