If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Combo Box with 3 fields from a table

I have a combo box in a form that I want to show 3 fields in:

Part_Prefix, Part_No, Part_suffix.

I am using the Select statement to get the information for the combo box. When you click the arrow button on the combo box you can see all three fields. However when you select one of the records listed, it only selects the first column. I cannot figure out how to get the combo box to select all three fields.

Re: Combo Box with 3 fields from a table

Originally posted by sbr7770
I have a combo box in a form that I want to show 3 fields in:

Part_Prefix, Part_No, Part_suffix.

I am using the Select statement to get the information for the combo box. When you click the arrow button on the combo box you can see all three fields. However when you select one of the records listed, it only selects the first column. I cannot figure out how to get the combo box to select all three fields.

Please help.

Thanks,

SBR

Comboboxes display ONLY the 1st visible column ... If you want the display all 3 items, they will have to be concatted together into a single column ... You can do this AND have the items in separate columns ... Just display only the combined items column ...

Re: Combo Box with 3 fields from a table

Re: Combo Box with 3 fields from a table

Originally posted by M Owen
Comboboxes display ONLY the 1st visible column ... If you want the display all 3 items, they will have to be concatted together into a single column ... You can do this AND have the items in separate columns ... Just display only the combined items column ...