Combo-box question

[Kevin Barnard]

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

[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

[Arno R]

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

[Kevin Barnard]

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