Select value in drop-down, runs query, returns results
Posted on 2011-02-15
Hello. I used your service years ago and loved it. I have returned to use again. Need your help on this one please. It has been years since I worked in Access 2007, so I am very rusty, so please bear with me. I work in a law firm. We have 200+ lawyers. Each lawyer can be assigned multiple cases at the same time. In my Access main table my data is stored. I created a form with a drop-down where I plan to have the user select their name and then want to have the cases associated with their name appear on the screen. I was able to program Access to have the lawyer name appear only once in the drop-down since many records in the main table can be associated with him/her. How do I:
1. Upon selecting of a lawyer's name, how do I get the only the cases associated with that lawyer to display on the screen?
2, Each lawyer is assigned a location: NYC (New York), WAS (Washington), PHL (Philly), MIA (Miami). One lawyer can be associated with multiple cities. How can I program Access that when he selects his name, the cases for him appear on the screen?
3. How I can program Access where, if in question #1 I select a lawyer's name and question #2 I select a city, I can receive records associated with that lawyer?
Thank you for your help!