Relationships b/t forms on Nav Form with top and left tabs

[Vodi]

Good day,



I'm working on a db that has a Nav Form with top and left tabs as a "switchboard." What I need to do is use a selection made on the first form (NSN Details, from combo box "Search NSN") to filter the rest of the forms on the left tabs: CAL Data, End Items, DASF, etc.




I'm currently only using the example CAL Data to get started.



Navigation form is called frmNMD_Switchboard
NSN Details form is called frmNSN_Notes
NSN Details contains text box [NSN] which is populated when a user selects an NSN from combo box [Combo155]
CAL Data form is called frmCAL
frmCAL contains field [PRIME_NSN], which is the field that needs to be filtered for the NSN selected on NSN Details.

So a user selects the NSN from the Search NSN combo box (Combo155) on NSN Details (frmNSN_Notes). This populates the data from a query into the form, including the NSN itself.
The user then needs to select CAL Data (frmCAL) to see the table with the data related to only the NSN selected on NSN Details (frmNSN_Notes).
The user also needs to be able to return back to NSN Details (frmNSN_Notes) and the NSN to still be selected (not having the form reload and having to select the NSN again).
The user will need to bounce back and forth between all of the left tabs without having to reselect the NSN on the NSN Details (frmNSN_Notes).

I've searched around and found bits and pieces and conflicting codes, but not what I need. Can anyone help? Your time and assistance are much appreciated.

[June7]

AFAIK, the way navigation form/control works is only one subform is available at a time - which means the NSN Notes form is not available for reference when the other subforms are viewed.

Suggest that when you select item on NSN Notes, set a textbox on main form or a global variable or a TempVars variable which can be referenced by the other subforms.