Column Order in a datasheet form

[MarionD]

Hi All,

I am trying to set the column order in a sub form. This depends on different settings in my options file.

I have on "got focus" of the sub form a sub with
Me.tblxx_Gemeinde_ID.ColumnOrder = 1
Me.vorschlag.ColumnOrder = 2
Me.tbl_Auftrag_ID.ColumnOrder = 3
Me.tblxx_Haushaltsabschnitte_ID.ColumnOrder = 4
Me.tblxx_Taetigkeit_id.ColumnOrder = 5
etc....
But the Field "Vorschlag" is an unbound field and will persist in claiming the first column!

Am I doing something silly??

Thanks for any ideas
Marion

 

[John Big Booty]

Perhaps this thread and the links within it will give you some ideas.

 

[vbaInet]

But the Field "Vorschlag" is an unbound field and will persist in claiming the first column!

That's because it's the boss

Do you have any other code in your form that also sets the column order or in some way interfers with it?

 

[MarionD]

Thanks Guys!

The "Problem" appears to be that I was using the gotfocus instead of the onload.

I have divided the sub into one setting the order on the Onload.

Works fine now.

Thanks for the prompt replies!

 

[vbaInet]

Happy to hear!