On my userform ExistingRentals I want users to be able to select a certain order by first choosing the Producing Organization (aka Customer) from all Producing Organizations in the database, then the Production (aka product) from any productions that have had in the past, and finally the Production Year (in case they have done that production in multiple years). By selecting these 3 variables a single record should be found and the rest of the form populated based on that data. I have no idea how to do this past populating the first combobox with all Producing Organizations.

I have attached my file for your reference.

Thank you!
Rentals- Current.xls