combo box 2nd column value

[Guest]

Hi
I would like to populate a field in my form with the value of column 2 of my
combo box
i have tried
me.desc = me.combo1.column(2)
but this does not work
me.code = me.combo1
populates field code with first column of combo box
is it possible to capture column 2 value
Thanks
Tina

 

[Roger Carlson]

Combo box column indexes are numbered starting at 0 (zero), so try:
me.desc = me.combo1.column(1)

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Hi
Sorry if I wasted any ones time just found out columns start at zero
Tina