Unanswered: Query Criteria from Multiple List Boxes
I'm trying to create a query where the criteria's are pulled from two list boxes. Right now, I've managed to query from the Vendor list box. I'm stuck now as I have no idea how to add a second criteria to the query by using the Deptartment# list box.
I have attached my work-in-progress. Please take a quick look and any help is greatly appreciated.
As I'm trying out your suggestion, I'm starting to see a problem. I think your sample application would only work if each line in the table is unique.
On the other hand, say if there are 10 entries with last name of Doe in the table. 5 of them are from WI and 5 are from MN. In order to pull a report of employees with last name of Doe from MN, you would need to manually select all 5 Doe's in the list box instead of just selecting one. If you want to just select Doe and wish to pull reporting for all employees that have a last name of Doe, then you must use a query.
Does that make sense? See attached zip.
Thanks again for your help and suggestions. Really appreciate it.
Well, if you're looking for all the Doe's, I might do it differently. Let's nail down exactly how you want to use this. Do you want listbox selections to find the specified person, or anybody with that name? Maybe you want to add a textbox or combo to find anybody with that name?