Requery Subform inside a Subform

[ccondran08]

Hi, I've searched high and low for this but still cant find anything.

I have a main form (frm_Main_Menu) which has a Tab Control with a series of tabs. Inside one of the tabs is a subform (frm_Red_Green) with another Tab Control and inside one of the two tabs is another subform (frm_Red_Filtered subform). Can someone please give me the VBA syntax so I can requery the (frm_Red_Filtered subform). I have tried the following codes but is not working ;

Forms!frm_Main_Menu!frm_Red_Green.[qry_Red_Filtered subform].Requery

 

[AccessBlaster]

Have a look here for ideas. http://access.mvps.org/access/forms/frm0031.htm