Help with navigation forms in Access 2010 (1 Viewer)

[JJNero]

I have a Main (Home) form that has a sub navigation form (frmNavigationSubform).

Need to access 3 forms. Forms 1,2 and 3. Also, have 1 options form.

Subform has 2 Navigation buttons. NavigationButton2 and NavigationButton3.

NavigationButton2’s Navigation Target Name = 1 (frm #1).

NavigationButton3 has no Navigation Target Name. This is passed on when user picks Option1 or Option2 form options pop screen.

Now I can pass the name to the Navigation Buttons2 but the subform does not show it. I have to click on the Navigation Buttons2 again for it to show.

What I want is when the user makes the choice in the options screen the name is passed and form 2 or 3 should load/show. :banghead:

Please help

Thanks in advance
bd attached

 

[clarkcovey]

You will need to reference the subform, in your case, "frmNavigationSubform" and specify the source with "SourceObject."

Private Sub Command50_Click()
[Forms]![Home]!NavigationButton3.NavigationTargetName = "2"
DoCmd.close
Forms![Home]!frmNavigationSubform.SourceObject = "2"
End Sub