update subform requery other subform

[tubar]

i have a main form with three sub forms on it. when i update subform 1 i want subform 2 and 3 to update...can some one help..currently i have an after update event in a combo box subform 1

[Forms]![FRMDATESUM]![frmHOURSUMnowork].Requery
[Forms]![FRMDATESUM]![frmHOURSUM].Requery

when the user updates the combobox in subform one nothing happens to the other subforms until close and reopen main form

 

[tubar]

[Forms]![frmdatesum]![frmHOURSUMnowork].Requery
[Forms]![frmdatesum]![frmHOURSUM].Requery

this worked by placeing the vba in the onexit.

 

[TJPoorman]

You need to reference the form property before requery.

[Forms]![frmdatesum]![frmHOURSUMnowork].Form.Requery
[Forms]![frmdatesum]![frmHOURSUM].Form.Requery