Call Click event in nagivation button from subform

[Malalex]

Hi there,
I have a navigation form which has 2 tabs. One is contains all the records in the table, I show them using a datasheetview, the 2 tab ( or navigation button) shows the details of the records.


this works ok, the user select the record in the datasheetview and can click in the 2 tab to see more details.
But the the user wants to access the 2 tab wen double clicking in a a record in the datasheetview. I thought was easy.. :-/ . but I have problems

What I have done is:

1) on event Double click of the datasheetview I put the setfocus in the tab 2

Me.Parent.Parent!NavigationButton9.SetFocus

2 ) in the gotfocus of tab2 I call the click event

Call NavigationButton9_Click



When I hit the click event Access crashes... So obviously I cannot use this approach...


I have access 2016. Any idea on how to tackle this?

Thanks!

Alex

[CJ_London]

Navigation forms have their limitations, but on the basis the form is open, try

1. change the Private for the event to Public (so it can be referenced from outside the form)
2. then instead of your call, use Form_nameofyourform.NavigationButton9_Click


may not work because it is a navigation form, but that is how you call subs and functions in other forms

[Malalex]

Hi Ajax, thanks for your reply. I found the way to trigger the event without breaking Access
I set the focus and sent the enter from the double click event in the subform.
It is kinda slow but works

Private Sub Form_DblClick(Cancel As Integer)




Forms![Navigation form]!NavigationButton9.SetFocus
SendKeys "{enter}", True


End Sub