Split form

[billheath]

I have a split form which I use to track hours worked per day per project.
The Top part is used to enter the project information including date, and a description of the work completed.
The split portion lists all projects worked on that date, number of hours each, etc.

How do I arrange the text boxes in the datasheet in a particular order? For instance, the datasheet looks like this:

Date --- work description --- Hours Worked --- Project # ----- Project Description
I want to reorder the datasheet so that Project # is the second item:

Date--- Project # --- work description --- Hours Worked ----- Project Description
I can change it while the form is displayed; However, when I close and reopen the form, The data is back to the original order. I have tried changing the order in the table and tab order with no luck. I can't find a way to change it in the property sheet. Any help would be greatly appreciated.
Thanks, Bill

 

[kjv1611]

I believe that what you need to do is write a query with the fields ordered the way you want, and then base the data table on that query. I've not done that one in a while, so I'm trying to remember and guess a little to boot.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

 

[kjv1611]

But thanks for asking the question - made me think of an extra idea of a side database I've piddled with off and on for a couple of years. Maybe I'll add something like this to it as well.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

 

[billheath]

Thank you for your help. I will try it and let you know.

God bless

 

[MajP]

If that does not fix it, you can always specify the column order. To set the column order you can do this in the on open event. You have to refence the control name and not the field name. Sometimes they are different, so be careful.

Private Sub Form_Open(Cancel As Integer)
  Me.txtBxEmployeeid.ColumnOrder = 2
  Me.txtBxlastname.ColumnOrder = 0
  Me.txtBxFirstname.ColumnOrder = 1
End Sub