I have my form that allows you to choose the year and month so the sub-form will automatically filter to only those transactions.
This works fine BUT when I created another qry and subform to only show the Grand Total Of transactions It will not update the data when a new date is selected
Subform on the bottom of the form works and updates fine
Subform on top will not update unless I move back and forth from design view.
Thanks