We help IT Professionals succeed at work.
Get Started

Call procedure in subform on tab control from main form

marcchevalier
on
110 Views
Last Modified: 2016-02-11
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
CERTIFIED EXPERT
Top Expert 2016
Commented:
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE