ExcelChampion
Well-known Member
- Joined
- Aug 12, 2005
- Messages
- 976
I'm trying to figure out how to write a query for the row source of a combo box.
In a table I have Fields: Prod1, Prod2, Prod3. Consider these the headers.
Let's say in Prod1 I have, "ABC", in Prod2 I have, "123", and Prod3 I have "XYZ". These are all in the same record (same row.)
I would like the combo box to be populated with a list of:
ABC
123
XYZ
A simple Select statement only populates the combo box with ABC, leaving the other two items left out.
In the row source, is it even possible to create a query statement that will show Prod1, Prod2, and Prod3 items in a list? The only way I can think to do this is to have the list values queried to a table under a single header (field) and then query from that. But that seems inefficient.
Any ideas? Thanks.
In a table I have Fields: Prod1, Prod2, Prod3. Consider these the headers.
Let's say in Prod1 I have, "ABC", in Prod2 I have, "123", and Prod3 I have "XYZ". These are all in the same record (same row.)
I would like the combo box to be populated with a list of:
ABC
123
XYZ
A simple Select statement only populates the combo box with ABC, leaving the other two items left out.
In the row source, is it even possible to create a query statement that will show Prod1, Prod2, and Prod3 items in a list? The only way I can think to do this is to have the list values queried to a table under a single header (field) and then query from that. But that seems inefficient.
Any ideas? Thanks.