Access use multi column ListBox on popup form to load multicolumn source combobox
Hi
I am using the following code behind a button click to open a form whose code is shown further on. This loads a listbox on the form.
When the user makes a selection from the listbox it sends this back to my original ComboBox.
The listbox has one column. I now want to do this for a multi column combobox and listbox. How do I do that?
Thanks
Private Sub btnManufacturer_Click() oForm = Me.Name oCombo = Me.Manufacturer_Combo.Name DoCmd.OpenForm "f_List", , , , , acDialogEnd Sub
You can use a multi-column rowsource for the combo box.