Multi-Column Combo Box

[MattWhiteley]

Hi, this is probably something very simple that I'm overlooking but I have a problem with a combo box on a form. To give a brief overview I have a "Jobs" table, in that table is a "Parts Required" and "Parts Used" field that is linked to a "Parts" table. This table contains 3 fields "PartName" "CataloguePartsNo" and "DBTPartsNo". I also have a "JobsForm" for the "Jobs" table, on the "JobsForm" both fields have combo boxes that allow multiple values, when you click the combo box it shows all 3 fields, however once they're selected only the first field shows, I would like all 3 to show.

Any help?

 

[CJ_London]

once selected, only the first visible column will show. If you want the others to be visible then for each one create an unbound textbox and in the controlsource put

=mycombo.column(2)

where mycombo is the name of your combo control and 2 is the column number (Note first column is 0 - bound column=1 means first column, which is just an inconsistency you live with!)

 

[MattWhiteley]

Thanks, I actually managed to solve the problem myself by simply making a query that combined the fields. After an hour of messing around, I didn't manage to click on the simple resolution until I'd asked. Thanks a lot anyway.