On click event

[smk23]

I would like to call a public sub routine on a subform when a parent tab
control is clicked. What would be the syntax for that?
Thanks

 

[Graham R Seach]

Sam,

Private Sub TabPageName_Click()
Me.subformcontrolname.form.procedurename
End Sub

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[smk23]

Thank you Graham. I think you Aussies must have all the answers.
Sam