Requery ALL Subforms?

[paindivine]

I have a form with 3 subforms. 1 in the header, 1 in the detail and 1 in the footer. I would like to refresh all 3 every 10 seconds.

I can only get it to refresh 1 by putting this in the ontimer:
=Forms![MAIN FORM]![Subform].Requery
How do I do multiple forms at once? And if it's code, please tell me exactl what to put in the code because I'm a noob to VB. Thanks!

 

[paindivine]

Nevermind, I figured it out

 

[tehNellie]

Would it have hurt to have answered your own question so that when this thread crops up in search results it might yield some useful information?