Getting from a subform to a parent form button_Click

[d9pierce1]

Hi all,
See Code Below
I have a ParentForm and SubForm
On the sub form I have a button "OpenBalance"

When I click this button depending on Case Select
If Case 5 then I want it to Click the LoanCalc button on the parent form.
I have tried all sorts of stuff and cant get it to compile....

Private Sub CmdOpen_Click()


Select Case Forms!frmAccount!CboAccountType


    Case 1, 2, 3, 4  'Asset, Expense, Income, Liability(ST)
        DoCmd.OpenForm "frmOpenBalance"
    DoCmd.GoToRecord , , acNewRec
    Forms!frmOpenBalance!CboToAccount = Me.AccountID
    Forms!frmOpenBalance!TransAmount.SetFocus
    
    Case 5 'Liability(LT)
    Forms!frmAccount!CmdLoanCalc.SetFocus
   Call Forms.frmAccount.CmdLoanCalc_Click
    End Select
End Sub

Thank you all

[davegri]

Call Form_frmAccount.CmdLoanCalc_Click

or perhaps

Call Me.Parent.cmdLoanCalc_click

[d9pierce1]

Hi davegri,
Well neither worked but Call Me.Parent.cmdLoadCalc_click did compile, just gave an error when run
The other method wouldnt compile
Thanks

[Welshgasman]

Hi davegri,
Well neither worked but Call Me.Parent.cmdLoadCalc_click did compile, just gave an error when run
The other method wouldnt compile
Thanks

Have you walked through the code with F8?

[Gicu]

Have you switched the CmdLoanCalc_Click from Private to Public? Once you do that try calling it like this:

Call Form_frmAccount.CmdLoanCalc_Click

Cheers,

[d9pierce1]

Sure, I am getting an application-defined or object-defined error
run time 2465

[d9pierce1]

Thank you Vlad,
Worked as smooth as silk
Dave