SPLIT FORM COLUMN ORDER

Question

I am trying to set (or reset) the column order in the Split form at the bottom.  I have tried changing and saving the new column order in DataSheet View, Layout View, and Form View.  But when I close and reopen it goes back to the old/previous column order.  I also tried resetting the tab order, but so far nothing seems to hold the new/changed column order.  Any ideas appreciated.

Answer 1

Did you try creating a completely new form from the new query?

Answer 2

Megan - Right.  The query contains about 6 tables.  So I made a copy of it and rearranged the fields in the query copy.  Then made the copy the record source for the form.  The old column order still remained so I rearranged the column order in the 'DataSheet' and 'Layout' view but the old column order returns.

Answer 3

No problem.  I think I understand what you'd like to do now.  If changing the order in the query isn't working, the only thing I can think of at the moment is changing the order of the columns in the table, though I hesitate to make any changes to tables because of potential cascading consequences.  Also, your query might include fields from multiple tables so I'm not sure it could work even if it would otherwise.

Might be best to restart the form.  Or, another idea just popped up - build a new query and then make it the Record Source of the split form.

Answer 4

MMegan - Thanks for reply - The issue is the order of the columns (not the sort), e.g., In the query the columns are A, B, C, D from left to right.  But, the split form the view at the bottom displays columns ordered as C, D, A, B.  Is there a way to get the column order in the lower part of the split form to display as in the query...i.e., A,B,C,D --- without re-doing the entire form setup.

Answer 5

Using the query builder in the form and sorting the field through the query may work.