Display combobox column values in rows

[unknown2u]

I'm not sure if this needs vba but I haven't found a simple answer on google... maybe a wrong choice of keywords

I have a combobox where I want to get its values from five different columns in one table.
I can use an SQL query to get it but it's displayed in 5 different columns in a big table.
I want each value of each column to be displayed as a separate row in the combobox as 1 column...

Any ideas?

Thanks in advance

 

[CJ_London]

not sure why you want to do this - sounds like your db has some design flaws - only suggestion i can make is investigate union queries

 

[unknown2u]

No design flaws. It just serves a different cause them what you'd expect.

Any other help to offer?

 

[arnelgp]

use union query:
select column1 from table1
union
select column2 from table1
...etc...

 

[unknown2u]

Great! Thanks, I read about it some more and tried changing it till it worked.

I figured it has something to do with that union thingy but I thought there might be an easier way to do that in the properties of the combobox...

Thanks again!