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

Combo-box question

P: n/a
I've got a combo-box drop down list with 2 columns. Both these columns are
displayed in the list. But only the primary column is displayed in the field
once I've made my selection from the list. Is there any way I can display
the information from both columns?
Thanks
Kevin
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
HJ
You can use a query that contains a 'column' with the combined data. The
query column can be like this: CombinedColumn: [Field1] & " " & [Field2]

Then use the query and the combined column in the combo box.

HJ

"Kevin Barnard" <ra*******@hotmail.com> wrote in message
news:bi**********@ctb-nnrp2.saix.net...
I've got a combo-box drop down list with 2 columns. Both these columns are
displayed in the list. But only the primary column is displayed in the field once I've made my selection from the list. Is there any way I can display
the information from both columns?
Thanks
Kevin

Nov 12 '05 #2

P: n/a
Kevin,
You can add another field next to the combo.
Set the Controlsource as =ComboName.Column(1)
This will shows your second column (Counting starts at 0)
Look in Help for 'Column' if you need more information.

--
Hope this helps
Arno R
"Kevin Barnard" <ra*******@hotmail.com> schreef in bericht news:bi**********@ctb-nnrp2.saix.net...
I've got a combo-box drop down list with 2 columns. Both these columns are
displayed in the list. But only the primary column is displayed in the field
once I've made my selection from the list. Is there any way I can display
the information from both columns?
Thanks
Kevin


Nov 12 '05 #3

P: n/a
Hi Arno, thanks for the help. It works beautifully.

Cheers
Kevin
"Arno R" <ar****************@tiscali.nl> wrote in message
news:bi**********@reader1.tiscali.nl...
Kevin,
You can add another field next to the combo.
Set the Controlsource as =ComboName.Column(1)
This will shows your second column (Counting starts at 0)
Look in Help for 'Column' if you need more information.

--
Hope this helps
Arno R
"Kevin Barnard" <ra*******@hotmail.com> schreef in bericht

news:bi**********@ctb-nnrp2.saix.net...
I've got a combo-box drop down list with 2 columns. Both these columns are displayed in the list. But only the primary column is displayed in the field once I've made my selection from the list. Is there any way I can display the information from both columns?
Thanks
Kevin


Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.