Command button on report

Posted on 2011-10-21
Last Modified: 2012-05-12
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.
Question by:ssmith94015
    LVL 61

    Expert Comment

    Not in 2003.

    That feature was added to the "Report View" in A2007.
    LVL 61

    Expert Comment

    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.
    LVL 74

    Accepted Solution

    Not in Access 2003
    But you can do this via Main/Popup "form".

    This is possible in Access 2007 and higher though.

    But you will have to clearly define "Master" and "Detail", because the master Report may contain many Master records, so you would have to "Filter" the popup report for just one certain Master record.

    If your Master Report listed customers, you would have to "Select" a customer, then filter the "Orders" report to only show Order records associated with the selected customer.
    Make sense?

    LVL 61

    Assisted Solution

    Sorry for the multiple posts...

    < I want them to be able to preveiwe the report and on a particular record, view the details. >

    However a user would not be able to "select" a particular record from a report the way they could from a form.  If you needed that type of functionality you would have to use a form to allow record selections in conjunction with your report.
    LVL 21
    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.

    Author Closing Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Many companies are making the switch from Microsoft to Google Apps ( Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
    The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now