1 main two subforms

[mychalB]

I have one main form, mainA and two subforms lets call subA and subB.

when I add or update information in subA I want to requery a combo box on subB.

I put this in an after_update event in subA, but it doesnt seem to work.

Form![mainA]![subB]![cbobox].requery

the error message that I get is unable to find subB any thoughts?

thanks in advance.

Mychal

 

[tomschafer]

You need to reference the subform as a control on the main form before referencing it as a form...
Forms![mainA]![subBControlName.Form![cbobox].requery

Check out this link...

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q113352