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!
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!
