Combobox bound column

[Daniel Tan]

Hi, how can i obtain the value of combobox multiple bound column data
? Eg, if i select combo box, it has more than one field, name and age
and id listed. Pls advise, thanks.

Regards,
Daniel

[Scott McDaniel]

Me.NameOfYourCombo.Column(0) ... assuming the first column is bound ...
combobox lists are zero based

--
Scott McDaniel
CS Computer Software
www.thedatabaseplace.net

"Daniel Tan" <da*******@time.net.my> wrote in message
news:6a*************************@posting.google.co m...

Hi, how can i obtain the value of combobox multiple bound column data
? Eg, if i select combo box, it has more than one field, name and age
and id listed. Pls advise, thanks.

Regards,
Daniel

[Larry Linson]

"Daniel Tan" wrote

Hi, how can i obtain the value of combo
box multiple bound column data? Eg, if
i select combo box, it has more than one
field, name and age and id listed. Pls
advise, thanks.

A Combo Box, by definition, has only one bound column and that is the
default property if you refer to the Combo Box... e.g., Me!cboDepartment
will return the currently-selected entry's bound column.

If that Combo's drop-down list were defined to include n additional Columns,
they are referenced by

Me!cboDepartment.Column(0) -- the first one
Me!cboDepartment.Column(n-1) -- the last one

Note: the "Me" shortcut is available only in the Form's module. If you are
referring to the control from another module, you need to use the
fully-qualified notation

Forms!<yourformname>!<yourcontrolname>.Column(x)

Larry Linson
Microsoft Access MVP