Changing Navigation Target Names via VBA within Navigation Form

[McArthurGDM]

Hi,



I have a Navigation Form with Tabs. To specify what subform gets loaded within the Navigation Form when you click a Tab, you select a specific Navigation Target Name.

I was curious if anyone knew how to call this option in VBA so that I can switch between forms under one particular Tab. That is, ideally, if I click a button, it switches to a different form under the same particular Tab. I believe this can be done by changing Navigation Target Names and refreshing.

Thanks

[ranman256]

On the TAB.CHANGE event:

Private Sub tab1_Change()
'MsgBox tab1.Value
Select Case tab1.Value
    Case 1
       SubForm.SourceObject = "frmSubEmp"
    Case 2
       SubForm.SourceObject = "frmSubPHONES"
End Select
End Sub

[June7]

If you are using Navigation form/control, see if these help
https://www.accessforums.net/program...tor-42740.html
https://www.accessforums.net/access/...rms-41949.html

[McArthurGDM]

Thanks for the input guys. Unfortunately, I don't think these replies address the issue.

Instead of changing Tabs on the Main Navigation form, I want the button to change the Navigation Target Name for that particular Tab. That is

I want the current subform to close and another subform to be loaded ALL WITHIN THE CURRENT TAB. I was thinking this could be done by changing the Navigation Target Name and refreshing the forms, but it didn't work.

You can call upon the Navigation Target Name in VBA, but it doesn't really work like I want it to. It's not the refreshing part either that's screwing up since I use sendkeys F9

[June7]

This is easy with a regular form/subform, whether or not a Tab control is involved. ranman's code should work for that situation, although not sure the Change event is appropriate.

I don't like nor use Navigation form. The referenced links are all I can offer.

[McArthurGDM]

The only reasonable work-around that I can think of is by setting the elements of a form visible or not visible and giving the illusion of two (or more) different forms. It works for subforms within the Tab, actually. You can turn these subforms visible or not visible - just not the main subform within the Tab (ie, the Tab Navigation Target). You can have one main Tabbed form and set subforms within it that you turn off and on with control sources. I would suggest taking this route with the next person that inquires about it.