Refresh datasheet-view subform’s column headings f
In my parent form, I have two child subforms as follows: 1 is the subform employee header; it defaults to single form view. The second is the subform hours; it defaults to datasheet view and contains hours-worked detail. One of the benefits of using datasheet view is that the user can use built-in Access functionality to hide/unhide columns at will. I thought that the second benefit would be: when the dynamic query (qryHeadings) linked to the datasheet subform changes to include new column headings/columns, then those new column headings/columns would refresh the linked subform datasheet the next time that subform was opened.
However, my tests of this theory are showing that only the fields present in qryHeadings when it was first linked to the datasheet subform display in that subform, even after qryHeadings shows new column headings and datasheet subform is thereafter opened.
Please help me determine the flaw in my design.