Populate TextBox with Combo Box Selection

[Court]

I have a form with a tabs of suppliers each tab having a ComboBox and text box.

Right now I am working with the Supplier Vetoquinol
Combo - VetCB
Txtbox - VetTB

each Supplier has its own table with products. In the Table Vetoquinol it shows:
Supplier ProductCode ProductName
VET 0122 Vitamins
VET 0123 Feed
...


Here is the Code
Option Compare Database

Private Sub VetCB_AfterUpdate()
Me.VetTB = Me.VetCB.Column(1)
End Sub


I know that I have to somehow reference the tabs but how so and even what I try this combo box and text box on the form it does not work!
I am trying to get the selection from the combobox to the textbox.
COlumn 1 is the ID

Just having no luck!

THX!

 

[rainman89]

Hi..

Take a look at this and let me know if it helps you
http://www.mvps.org/access/forms/frm0025.htm

 

[Court]

Well unfortunately it is still not working - Im trying to get both code and product name in the text box each on a new line. is there a way I can put my order form up so one can see it?

 

[Court]

Each product on a new line.