The same record selected in each list box within the form with tabs

[Orlando2]

I have a form with 3 tab controls. Within each tab, there is a bound list box that lists records based on a combo box selection. All list boxes are bound to the same table and records in each tab will be in the same order.
Tab1, listbox1:Field1, Field2, Field3, Field4
Tab2, listbox2, Field1,Field2, Field5, Field6
Tab3, listbox3:Field1, Field2, Field7, Field8,Field9
I would like the same record be selected in each list box within the tabs, e.g. when record #2 is selected on tab1, the same record will be selected on tab2 and tab3, or if I click on tab 2 again and change the selection to record #3, record #3 will be selected on tab1 and tab2.


Any suggestions? I've tried various searches with no luck.

[RuralGuy]

You know you can place your ListBox on the TabControl such that there is only one ListBox and it appears on all tabs, right?

[Orlando2]

Could you provide more details or some example? I am a newbie to Access.
My listboxes within tabs are based on the same table but won't have the same number of variables.

[RuralGuy]

I'm not sure what you are doing but if you 'CUT' one of the ListBoxes from a tab and then paste it back on your form without selecting a tab first, the List box is really on the main form and not the TabControl. Slide it over the TabControl and you will see that the tab pages are really transparent and the ListBox now appears to be on all of the tabs. You could do the same with the other controls that are shared in common with all of the tabs.

[Orlando2]

I did this. I copied the same listbox into each Tab. What I need is, when record #2 is elected on Tab1 I want record #2 be selected on Tab2 and Tab3. I have atttached screen shots how it should be. I will appreciate your help.

I'm not sure what you are doing but if you 'CUT' one of the ListBoxes from a tab and then paste it back on your form with out selecting a tab first, the List box is really on the main form and not the TabControl. Slide it over the TabControl and you will see that the tab pages are really transparent and the ListBox now appears to be on all of the tabs. You could do the same with the other controls that are shared in common with all of the tabs.

[RuralGuy]

Is there something wrong with having the same control on all three pages of the tab control? It looks like it would do what you want to me.

[RuralGuy]

If you want, just post your db and I'll do it for you to show you what I mean. It looks like a test db to me but if not then remove any sensitive data first.

[RuralGuy]

Ahh...it appears the RowSource of each ListBox is different for each tab. Is that correct?

[Orlando2]

Yes, it is correct. I attached the sample database. Thanks1

Ahh...it appears the RowSource of each ListBox is different for each tab. Is that correct?

[RuralGuy]

See if this works for you.

[Orlando2]

Yes, it works!!!
Thank you so much, you saved my life

See if this works for you.

[RuralGuy]

Excellent! Glad we could help.