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?