Short scenario:

I have a data collection form (25+ actually). The footer contains totals of the the selected data.

I use a subform to control what data is shown ( by fiscal year, by month, etc. ) by changing the main form's recordsource to the appropriate SQL Select.

Everything works great except for one very annoying problem.
When a form is first opened the footer does not show the calculated totals of the default data shown (current fiscal year, which is set by the subform), that is until the user moves to another record or selects a different view of the data. (I requery the totals on the main form's Current event)

Any ideas? I would prefer it if I could force the main form's Current event from the subform.

Another q:
In the quest for clean code is there any way for me to requery the total fields in the footer without explicitly calling the Requery method of each one of the controls?