Access report with graph

Posted on 2011-10-28
Last Modified: 2013-12-18
I have a report in access that has graphs and charts on it. using VBA I have filtered the data (customer name) and set the row source of the graph with my own SQL string. the report is then displayed in preview mode. all this works well and display's as required. The problem i have is when you then press the print button to print the report you get a dialog box  dilog box image asking for the value again (4 times) how can i show the preview and retain the customer name so that i'm not asked for it again..

Question by:AshridgeTechServices
    LVL 61

    Accepted Solution

    It sounds like your filter form is closing before you open the report.

    Resolving this may be as simple as ensuring that your form stays open in the background when you open the report.

    Can you show how the report is being printed?  Macro, VBA...?
    LVL 1

    Author Closing Comment

    thanks for the quick responce and for pointing me in the right direction.
    it was as you said the form needed to remain open
    LVL 61

    Expert Comment

    Glad that worked out :)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

    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

    19 Experts available now in Live!

    Get 1:1 Help Now