Goal: To be able to enjoy the features of a datasheet view (hide colums, freeze columns, and change column width), while maintaining the aesthetically pleasing column headers of a form view.
1. I took a table, and created two forms from it. The first form has only bound control boxes in the detail section of the form. I named all the fields, and set the default view to datasheet.
2. I placed all of the labels that I want to use as column headers in the form header section of the second form. Then I copied all of the control boxes from the first form and placed them in the detail section of the second form. I set the "visible" property to no.
3. Then, on the second form, I inserted the first form as a subform. I linked the child and the master to the same field, which is my primary key. I also removed the scroll bars and record selectors from the second form.
The result of my attempt: The datasheet appears in the subform below the column headers I want, but when I scroll the page to the right, the labels do not move with the datasheet columns. In other words, the two forms, the main form and the second form scroll independently of one another.
What is the best way? Am I heading in the wrong direction?
Did I describe what I want to do well enough? It would be so easy if I could just do an alt printscreen, and post it somewhere where you all could see it. A picture is worth a thousand words.