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?

-------------
Thanks,
Mark

Mark,

see if the attached word document helps.

If you need a Demo let me know

Edited by: jmcwk on Tue Jul 1 10:19:56 EDT 2008.

You may want to check out this page on The Access Web.

Hope this helps,

Dennis