call main form event from subform

[HomeGrowth]

My AfterUpdate event in subform, I want to call the OnCurrent event on Main Form. I tried these codes

Call Forms![MainForm].OnCurrent

or

Call Forms.[MainForm].Form.OnCurren

obviously, I am not doing right. any suggestions? Thanks

 

[PHV]

Make the event procedure Public instead of Private and then:
Call Forms![MainForm].Form.Form_Current()

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PWise]

how about

me.parent.Form_Current

I think it has to be decleared as public

 

[MajP]

I personally would not do it that way because it limits the useability of the subform. Now that subform has to be used within the main form. Instead I always simply trap the sub form event in the main form, and do not write any code in the subform

Public WithEvents subFrm As Access.Form

Private Sub Form_Load()
  Set subFrm = Me.subFrmCtl.Form
End Sub

Private Sub subFrm_AfterUpdate()
  MsgBox "sub form after update event trapped in main form"
End Sub

Need to make sure the subform has a module and that the after update of the subform has "[Event Procedure]" selected.

 

[HomeGrowth]

You are amazing. The code did work after the I declare the event as Public.

I also tested out MajP's suggestion. It works great.

Thank you