Copy into an excel sheet from selection in two dropdown boxes
I want to populate an Excel sheet from an Access DB.
Ideally I will pick a dropdown box with Name1 and a second dropdown box with name2.
From that I want to go to either an access DB or a hidden sheet and copy all the information that matches the Name1 and Name2 fields. I can use a query, a hidden sheet or whatever is the best way of doing this.