Auto filling textbox in tab control from combo box selection in form

[rharri1972]

Hello! I am a greenhorn with Access...COMPLETELY new. I have a customer table made. I have created a Customer Form with customer combo box and the address, city, state, zip, and Country as text boxes.
I have coded, linking all text boxes to the combo box so that on "change" the txt boxes populate with "their" fields based on the customer selected in combo box.

I also have a tab control created on the same form. The caption of the tab I am needing help with is Contact Mgr. In this tab I have a txt box for Contact Name, Phone, and Email. How do i make these txt boxes populate based on the customer selected in the combo box? All of the information is listed in the Customer Table.

Thanks for any help!!!

 

[rharri1972]

Is this possible guys? Am I just missing the lingo? Maybe its a subform that should be filled within the tab control. Either way I am trying to populate the info needed in the tab control when i select the customer from the combo box in the form.

 

[Micron]

Not sure what your issue is. A textbox on a tab control page is a member of the form controls collection so it shouldn't matter if a combo is on the form and the textboxes are on a tab control page. Not to be confused with the use of a navigation form - that's a different animal and sometimes people are referring to one when it's really the other.
Unrelated to your question but since you say you are new to Access I'd recommend you research database normalization if you haven't already.