Referencing subform on navigation form

[zozzz]

hello friends ,

I have a main Navigation called "Main_N1"
and sub Navigation called "Sub_N1"
and form called "Form1" with "Form1_sub"



vba code in Normally case :

Private Sub Cmd4_Click()
DoCmd.GoToControl "Form1_sub"
Forms.form1.Form1_sub.Form.Fname.SetFocus
End Sub

but how can I write this code for navigation Form ???

Navigation.zip

[aytee111]

Navigation forms are not commonly used by members on this forum. It is far easier to create your own "Main Menu", a form which controls everything else. Then all forms are treated as forms/subforms, without this interference.

[zozzz]

in fact, There is no way?

[aytee111]

Don't know.

[davegri]

Point is, Zozzz, we've all found out the hard way that an Access Navigation Form setup delivers a devilish level of complexity when trying to customize it. That messiness does not exist if you create your own navigation form from scratch. If you want the tabs at the top, you can use a tab control and put the subforms on the tabs. We all know how to do that and you will get plenty of help here if you go that route.

[June7]

Review https://www.accessforums.net/showthread.php?t=32053