Link to home
Start Free TrialLog in
Avatar of cdb424ttm
cdb424ttm

asked on

Report and sub report

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.
Avatar of Bob Lamberson
Bob Lamberson
Flag of United States of America image

It should be a simple matter of excluding the information you don't want, from your data source for the report. If you could post the code you are using, might be able to help a little easier.

Bob
ASKER CERTIFIED SOLUTION
Avatar of NBrownoh
NBrownoh

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cdb424ttm
cdb424ttm

ASKER

using access 2003 NBrownoh
no answer on this pelase give not points and close question out.
Thanks
CDB
The answer to your question is Yes it can be done.
If you would like to respond to the comments I'm sure someone can give you the help you apparently need.