Order of Controls

[Shaimaa T]

I have some texboxes that I want them to appear in datasheet view with a specific order.

How can I control the order given that I tried tab index and tab order but did not achieve the desired result?

 

[bob fitz]

Open the form in datasheet view.
Click the top row of a column (name of column) and drag it to the position required.
Close the form.
Reopen the form.
Columns should display in the order they were in when the form was closed.

 

[Shaimaa T]

I am able to do this with a form but not a subform.

Any ideas how to do the same with the subform?

 

[bob fitz]

I am able to do this with a form but not a subform.

Any ideas how to do the same with the subform?

It should work if you open the main form and then move the columns in the sub form. Then close the main form and reopen it.