Call procedure in subform on tab control from main form

marcchevalier
marcchevalier used Ask the Experts™
on
In Access 2007, I have a form (frmAdmin) with a tab control (SMtabs) whose 4th tab labeled "Decisions" has a sub-form with a VBA procedure called InitializeNow. Because of the nature of that subform, I use unbounded fields to point to records. All of that works perfectly. My issue is that I need to run one of the subform's routines, InitializeNow, as soon as the user clicks on the main form's Decisions tab. So, I use the tab control's Change event like this:

Private Sub SMtabs_Change()
Select Case SMtabs
    Case 3  ' Decisions tab
        ' Initialize
        Forms![frmAdmin]![sfrmDecisions].Form.InitializeNow
    Case Else
        ' nothing at the moment
End Select
End Sub


If I were examining a field on the subform, this would work, but when I try to run an event, I get the lovely:

Run-time error 2465
Application-defined or object-defined error

with Debug stopping on my Forms line - It has nothing to do with the contents of InitializeNow. Should I be able to call that procedure from the Change event?

Thanks,

Marc
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
you have to make the sub procedure Public

change Private InitializeNow
to
Public InitializeNow

Author

Commented:
Thanks, Rey! That was it.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial