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....
Code:
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