Refresh subform in access 2010

[lkates]

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?

[orange]

See this for syntax
http://www.mvps.org/access/forms/frm0031.htm

[lkates]

Since i have to use macros, i don't think i can use the VBA code from that site. Also, my subforms are not linked to the main form (Link Master Fields and Link Child Fields properties are blank). If they were linked, the update would be automatic, but that wouldn't work for this form. I actually solved the problem with two commands in the embedded macro for the contol After Update event:

GoToControl
Control Name [the name of the subform control on the main form]

Requery

[orange]

Glad to hear your problem is solved.

[MeganHappeCook]

GoToControl
Control Name [the name of the subform control on the main form]

Requery

This didn't work for me, unfortunately. Perhaps settings in my database were interfering.

However, a macro to browse to another form and then back to the original form got my subform to refresh.