Displaying Multiple columns in a Combobox

[lab]

Hi All,

I am trying to display multiple columns in my combo box once the selection has been made.

To elaborate.. I have a list of suppliers with all their relevant info in one table (supplerID, supplier name, city, address, phone number, etc). At this stage, some of my suppliers are the same company, but have different warehouses in different cities. They are listed as seperate suppliers as the billing is often different depending on which city it comes from.
So what I am wanting/hoping to do, is be able to display the supplers name AND city in the combo box on the form, once the user has made the choice.

I have no problem getting the combo box to function correctly with all the data I need in the drop down, and I have the combobox bound to the supplerID. The problem I am having is once a selection has been made, I can only get the combobox to display the suppliers name OR city, not both.


To make things easy for the users (plus it helps with the layout of my form), I would really like to be able to display both columns on the form without the need to add a second text box that updates off the combobox.


Thanks in advance for any help,
Lee.

 

[KenHigg]

Maybe you can combine them in the rowsource query. ?

 

[lab]

Actually thats not a bad idea, and if there is no easy way to do it, I will go with that. but I like how the combo box seperates them in the dropdown...


EDIT: Playing around with kens suggestion, I added another column to the query that was the Supplier and City combined the way I wanted, but made the column 0.002cm wide, so it still technically counts as the first visible column (and therefore is shown when the list is closed), but doesnt actually display in the list while open.
So i now get he data I want in the combo box, and the seperated values in the list.


Lee.