Sandra Smith
asked on
Command button on report
In an Access 2003 report, is there any way to put a command button on the report so in previe mode, the user can hit it to bring up another report? The main report has master records, but I want the user to be able to view the detail without having to go back to the menu. I want them to be able to preveiwe the report and on a particular record, view the details.
In Access 2003, you can do that sort of thing using a popup form while the report is open, or through a commandbar menu above the report.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In Access 2003 I handle this by using a form that looks like a report.This allows me to have a drill down feature. If the user does want to print it I use a report.
ASKER
Ok, seems that what I want may not be as simple as I wish. They are upgrading to Access 2010 soon so I may just wait until then to provide this funtionality. It was a "nice to have", but not a deal breaker. Jeff, yes it did make sense and thank you both. there is another report that holds master/subclaim pairs only, so for now, they have the information and I am not going to pursue this until the upgrade. This is just another basis to push the upgrade forward. I do not want to use a form as they need to print the report and I would have to go back and create another form. They are good for now.
That feature was added to the "Report View" in A2007.