Position of columns in the table below a split form

[Frankie_The_Flyer]

Hi Accessers!
I've created several Split forms that have the data input fields in the form with the relevant query datasheet shown below.

As you tab through the form fields, the various cells in the datasheet are highlighted and move across the data row (as one would expect!). I want to put a particular field / Column at the start of the datasheet so that it's always available for view, but it seeme that what ever I do the column ends up back at the very far end of the data row!

I've sussed out the "Freeze Fields" facility which will keep the first column visable whichever cell is highlighted across the data row.

The column I want as the first column currently sits at the far end of the data row. So far I have dragged the row to the first column position; I've arranged the Query driving the form so that the column is at the front of the row, both in design view and in datasheet view, but to no avail. Everything I do to put the column at the start of the row in the datasheet shown below the form ends up with it back at the far end of the row the next time I open the form :banghead:

Any ideas how I can make this column stay where I put it please??

 

[Galaxiom]

Forget the split form and build a form-subform structure. The problems will go away.

Split forms have an incomplete object model that limits their versatility particularly under automation.