I’m using Access 2003; I have a report in my database which has a sub report on it.
I use this for keeping track of family drugs. Who is taking what and so forth. I the main report I have a listing of all the drugs for that family member. At the top of the report is where the sub report is. This report only shows the names of the doctors for that member only. My question is how to hide the sub report for all the members of the family except for dad. So when I print the report for my dad it show doctors name but when I print it for others I don’t want the sub report to show. Can this be done?
Thanks for any help.