I'm trying to create a database for an operator to choose values from a dropdown list. However, the source of these values are calculated (in a different query) in different columns (long story). I need to be able to choose any single value from multiple columns. I have tried to stack/combine/join but have not been able to find a function that will allow me to combine the columns (which are constantly updating).

I'm bretty new to VB Editor but thought there might be a way to do this.

Thanks for your help!