subform requery

  • Thread starter Thread starter skk
  • Start date Start date
S

skk

Hi!
I have frmA(main), fsubB(subform of frmA), fsubC(subform of frmB). I want
to requery fsubC, when fsubB.combobox value changes/after update event. I've
tried below code and many others with no success. Please help. Thanks.

Forms![frmA]![fsubB]![fsubC].Form.Requery
Me.fsubC.Form.Requery
 
The correct syntax is
Me.Parent.fsubC.Requery


If fsubB is a subform, rather than just a combo box, and you have linked the
2 subforms using the Link Master/Child Properties, then the requery will go
into the OnCurrent Event of fSubB.

Evi
 
Back
Top