>I have a grid that is part of a one to many relationship. The grid shows the many records, which works fine. The problem is the field order.
>
> In the grid I set the control source to a table called trandet. I have set the grid up to use text box controls. I have set the text boxs up to use the fields I want Ex:
>
>The data comes in as trandet.field1,trandet.field2,trandet.field3,etc..;
>I want the grid to show field5,field3,field6, in that order. I set the textbox controlsource in the fields in this order, but when I run the form the fields show up in the order of the table 1,2,3 ect..;
>
>Can't I control the field order of the grid display?

Hi William,


Set the corresponding column.controlsource in the desired order instead of textbox.controlsource