Updating text box with the diplayed item in the combo box

  • Thread starter Thread starter FA
  • Start date Start date
F

FA

I have a little issue hoping anybody can resolve it. I have a combo box
cboTesterName which is based on a lookup table Tester. I have a textbox
called Tester on the same form which is unbound and i want this textbox
to show whatever is displayed in the combobox cboTesterName.
I tried in the form's current event:
Me.Tester = Me.cboTesterName.Column(0)
I also tried
Me.Tester = Me.cboTesterName.ItemData(0)
But i all i am seeing in the textbox Tester is the ID number from the
lookup table.
Lookup table has ID and TesterName. Combo box displays the TesterName
but i want the same name to be displayed in another unbound textbox.

Any help would be great!
Thanks
 
Why would you want to do that? Seems kinda redundant.

I think you need to adjust the column you are pulling from.
 
You could try updating the textBox from the combobox Change() event?
ex: Textbox1.Value = Combobox1.Column(1)
 
Back
Top