By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,486 Members | 2,152 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,486 IT Pros & Developers. It's quick & easy.

Combobox bound column

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
"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
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.