I have a calendar UI written in Access 2010 using only macros so i can eventually publish it on the web. It displays records in a TODO list. Each day on the monthly calendar has a subform based on a query with a where criteria which is a TempVar set by macros. The temporary variables are being set by macros fired when either the parent form is first loaded, or when the user selects a new date from a control on the parent. The first time the UI displays it all works very nicely, but i cannot get it to refresh the subforms when the user selects a new date. If i go out of the form and back in, the last date set shows, so the TempVars are being properly set. How do i refresh the subforms from a macro fired by an AfterUpdate event (or any other event) on the parent's control?