I have a ComboBox that filters employee names. When you select an employee it populates a list box with only those customer records for that employee, from which you can then select the customer record you want and populate the form with that customer's data.
I would like to create a "Select All" in this ComboBox that retrieves all the records associated to that table and populates the ListBox with all the records
I saw a previous post where Jack provided a sample db for doing this with a ComboBox which opens up a datasheet when selected. Is there a way to fill the ListBox instead?