Quote Originally Posted by CreganTur

What does this mean for you? I'm guessing that your rowsource for your second listbox is dependant on a SQL string that uses a WHERE clause that's dependant on the value of listbox 1. If you want to allow your users to select multiple items, then you're going to need to figure out how you can add the individual selected items into your SQL statement.
GeganTur,

Thanks for the advice. This is exactly I'm going to do. Use the loop to extract selections in listbox1 to a string which will form a WHERE clause to build a SQL string for the rowsource of listbox 2. Does this make sense?

What event would be good? afterupdate or onclick? or something else?

Thanks again.