Combo boxes

A

ascottphelps

I am trying to get the combo box to not only display the second column of the
combo box, but i want to use that value on my form. in other words if
searching through my combo box and i find an address, (address is allready in
my database alng with key number) i want the key number to show up in a text
box. i have the address and key number in the same table. i have tried
several ways to do it and have been succsesfull at both showing on the form,
however when i look at the table where i am trying to store the values, they
dissapere.........thank you... Andy.
 
D

Douglas J Steele

I'm not sure I fully understand your issue. However, you can refer to any
column of the currently selected item in the combo box as
Me.cboMyComboBox.Column(1), Me.cboMyComboBox.Column(2), etc. Note that
columns are 0 based: to refer to the second column, you'd use Column(1).
 
A

ascottphelps

--
Andy.
i tried that and got name#... here is what i am doing.......i have the form
open, on the combo box i look for an apartment address(that has allready been
entered in the table). when i find the address i want the key # assosiated
with the address to automaticaly show up on the form. this is probobly very
simple and i am just over looking it .............thank you
 
Top