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.

Requery the subforms when the parent form is changed. You can do this in the afterupdate eventprocedure of the parent form. The same goes in any of the subform: me.frmName.requery.

Let me know if this works for you.

RU1

Hi RU1, Thanks for your response! Just to clarify, the parent form does not change; it acts merely as a way to link the two subforms together via an employeeID field. The change should occur in the datasheet subform only (as the second subform only provides reference information); specifically, after the qryHeading is updated with new column headings (and the number of columns may increase from the previous qryHeading depending on the contents of a table) the datasheet subform should show all of the column headings that appear in the query qryHeading. Could you be explicit in your VBA code suggestions? I am experienced with MS Access (using macros previously) and SQL but am a relative novice with respect to VBA code. Thanks