• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 400
  • Last Modified:

Access report with graph

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

Thanks
0
AshridgeTechServices
Asked:
AshridgeTechServices
  • 2
1 Solution
 
mbizupCommented:
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...?
0
 
AshridgeTechServicesAuthor Commented:
thanks for the quick responce and for pointing me in the right direction.
it was as you said the form needed to remain open
0
 
mbizupCommented:
Glad that worked out :)
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now