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!

Do you mean VBA? Foget it! I thought this was the Access Forum!

I need to be able to choose any single value from multiple columns.

Hi

Do you mean the value picked will come from one column or will be the multiple columns combined on one row of the table/query ?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.