Reports Filtering a Chart report

[Chance1234]

must be missing something here,

I have several reports which im opening through code

DoCmd.OpenReport str_doc, acPreview, , str_filter

Now str_doc is the name of the report which comes from a drop down and str_filter is a filter string which is built up from a number of options on a form

for example [month] = 'April 04' AND [team] = 'Investment'

on my normal reports it works like a dream, but on my chart reports nothing happens


what am i missing ?


Chance,

Filmmaker, gentleman and up for parole shortly

http://WWW.5YLAC.S5.COM

,

http://WWW.HOWTOBESPOOKY.CO.UK

 

[dhookom]

Charts don't use the report's record source. A chart control has a Row Source property (much like a subreport). Any filter applied to the report isn't necessarily inherited by the chart. The exception to this is if you use the Link Master/Child properties.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.