Combo box fill Text box

Y

yiotaa

I have a combo box(officename) in a a form in which I select the office name
and I want that result to be shown in a text box. I did it but I get the id
of the office i select in the combo box (officename) and not the name.
Please help me!!
 
A

akphidelt

It's because when you create a combo box that uses a table or query as it's
row source it usually automatically adds the ID as the number associated with
the comboboxs pick.

So you can do multiple things to change this

1. Go in to the properties of the combobox, and go to "Bound Column" and
change it from 1 to 2.

Or if you go in to the event of the combo box you can change the

me.yourcombobox.column(2) instead of just me.yourcombobox

either one should work. Hope this helps.
 
Top