Click button on sub form to call click on the parent form?

[d9pierce1]

Hi all,
Just cant seam to get this to work? I am trying to click a button on a subform to click a button on primary form?
I have used this before but get an error message? not defined...



Private Sub CmdInventory_Click
Call Me.Parent.CmdInventoryList_Click
End Sub

Have the correct spelling, have tried Forms.frmAccountHolder.CmdInventoryList_Click
and nothing works?
What am I doing wrong here
Thanks
Dave

[June7]

Is the main form button click event declared as Public instead of Private?

[d9pierce1]

Hi June7
It is private, I will try making it public?
Have also tried this
Call Form_frmAccountHolder.CmdInventoryList_Click

[d9pierce1]

OK, Made it a public and now I get this error?
"You cant hide a control that has the focus"
Any solutions?
Wow....
Thanks

[d9pierce1]

OK, Its Fixed... Thank you
Private Sub CmdInventory_Click
Forms!frmAccountHolder!CmdInventoryList.SetFocus
Call Me.Parent.CmdInventoryList_Click
End Sub

Works beautifully
Marked as solved

[Welshgasman]

Why are you not using Parent for the setfocus?

[d9pierce1]

Not real sure, I could perhaps
Will try that out and see if that works!
Thanks

[Welshgasman]

You really should try to be consistent in your code.
It will help you later, when you have to come back to it.