Query column order - datasheet vs design view

[fhickler]

I'm in the process of learning the Access interface and I need to understand column ordering for a query in datasheet vs design views. It seems like I can change the column order in design view and that's reflected in the datasheet view, until I make a change in the datasheet view - from that point, changing the order in design view doesn't effect the order in datasheet view. Is there a way to "reset" it so that the datasheet view once again reflects the order in design view?

[ranman256]

when you view the datasheet, clicking SAVE will save that field order.
just drag the columns the positions then click save again.

[fhickler]

when you view the datasheet, clicking SAVE will save that field order.
just drag the columns the positions then click save again.

I think my question may have been misunderstood. Let me rephrase it more succinctly:

Once you change the order of columns in datasheet view, it no longer reflects the order in design view. How do you get datasheet view to again follow the order in design view?

[CJ_London]

in datasheet view, the initial order is set by the order in which fields are selected in the underlying query. If you subsequently add additional fields, they will be added in columns to the right. So far as I know there is no easy way other than deleting all the columns in design view and then selecting them again.

You might try a bit of code - something along the lines of this untested code in the form load event

dim I as integer
dim fld as field
for I=0 to me.recordset.fields.count-1
    me.recordset.fields(I).columnorder=i
next i