Thanks for your reply. Let me try to fine tune my question. I have 7 area reps. (Southern CA, Northern CA, AZ, NM, NV, etc. Can I use a drop box that when I select Northern CA. it will only print the Northern CA report. If I select NV, it will only print the NV report. If I want to print all area reps it will print all. My plan is to send the reps a pdf file to each area rep. This list will change as new member joins. Can this be done and if so, how?

---

Reply from Alex Hedley:

Create a parameterised Query that takes the choice from the combo/listbox and filters your data by that area.
Now create a Report based on that Query.
Have a button to open the report on that form.