want to use 2 fields for combo box row source (1 Viewer)

[kelsita_05]

I have a combo box that uses a query as the row source. That query picks a value from a form ([Forms]![Q & D]![Translator]. It works great.
Now, I want to add a second field ([Forms]![Q & D]![Translator 2]), so that it appears as another item on the list in the combo box. If I add it as a second column in the query, it doesn't show up in the combo box.
For a second I thought I could concatenate my query so it appeared as one column, but what I want to see is two separate values on the drop-down not two columns together.
Is this possible? I've done a lot of searching/reading/wishing I knew what I was doing, but no luck so far.

Thanks for your help!

 

[boblarson]

For a combo box you can only view multiple columns within the dropdown and the selection only shows the bound column (or the first visible column if you have the bound column's width set to 0". If you want to view multiple columns you will need to use a list box.

 

[Rich]

You haven't changed the Column count for the combo or added the Column width

 

[kelsita_05]

I changed my column count and I can see the second column now.
However, that's not what I want to see.
Instead of seeing
Translator / Translator 2
when I click the drop down and having to select both, since they are together as one option,

I want to see
Translator
Translator 2
and I only want to select one of them. I just want to be able to choose between translator and translator 2, I don't want to have to select both names.

Near as I can tell the lsit box works the same way- showing my two columns in the query as two columns in the list box instead of rows.

thanks!

 

[Rich]

What you are describing is Two rows, not Two columns you'll have to base the column on a Union Query, though god knows why

 

[boblarson]

Sorry, that's the way Access works. What you describe sounds like your database is not normalized and you have repeating columns for data that should be stored in rows.

 

[kelsita_05]

Union query = beautiful, wonderful, my day is now better!
Thank you!!!