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...
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...