Refreshing Combo Boxes in a Subform that is not Expanded

[SD007]

I have a single form that has 5 tabs. Each tab has multiple nested sub-forms.

I.e. Form -->
Tab1 : Sub-Form --> (sub) Sub-Form --) (sub - sub) sub-form)..
Tab2 : Sub-Form --> (sub) Sub-Form --) (sub - sub) sub-form)..

In Tab1, I add a record. On insert, this record should cause a nested sub-form's combobox in Tab2 to be requeried.

I use the following two lines of code in an After_Insert event:
Forms!frm_DE!dg_record!dg_recorddetail!dg_recordregistration.Form!Person.Requery
Forms!frm_DE!dg_record!dg_recorddetail!dg_recordregistration.Requery

This code works only if Tab2's sub-form is expanded. Does anyone know how to get this code to work if the sub-form is not expanded?

I appreciate any help or samples. Thanks.

SD

 

[SydneyGeek]

Not sure, but as a general rule Access regards hidden controls as disabled. I've found that data can update in those controls but event-driven stuff is out of bounds. If anyone knows a workaround, I'd be eager to find out too.

Denis