Hello I have a Form that has a Listbox with 8 columns in it looks something like this

RefKey | PartNo | OE_Number | FMSI | Position | Left | Right | Qty |

1 | AL-110| 116.00.22.014.00 | 3578 | Front | | | 2 |

is there a way to do this ?



My forms Record source is already set to the table I want the info to go into ( newCatalogTable )

is there a way for me to set more than 1 control source for the Listbox?

right now the only thing i can do is select one of the 8 fields above

thanks in advance