Combo boxes

[Guest]

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.

 

[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).

 

[Guest]

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

 

[Douglas J Steele]

Post the exact code you're using, and indicate where it's failing.