Linking Tab Controls (1 Viewer)

[cowboymb]

I am trying to have 5 tabs linked together so that when I select a record from the first tab it will update the other 4 tabs with the information relating to that record.

I know I can do this using a Main and sub forms by linking Master to child but that isn't what I am trying to accomplish.

Thanks for any advice.

 

[vbaInet]

I'm assuming each tabs have subforms so here -->

Let's say you want to link tab 2 to tab 3 via a field called CustomerID. This is what you do:

1. Drop a textbox onto your main form and set it's control source to the CustomerID field of tab 2, so the Control Source could look something like:

=[COLOR=Blue]SubformControlName[/COLOR]![CustomerID]

where SubformControlName is the name of the subform control on tab 2
2. Name the textbox txtLinkTab2
3. Set the Link Master Fields property of tab 3's subform control to txtLinkTab2. Don't click the elipsis button, you have to type it in otherwise it won't work.
4. Set the Link Child Fields property of tab 3's subform control to CustomerID, typed in too.

Done!