Microsoft
Just starting to run some more tests.
I'm wondering if the timing has something to do with it.
The reason I say that is when I open the Chart's query, the values are there. But they don't show up on the graph.
I created a new query that matches everything in my 1st query without using any Parameters and without the Criteria being pulled from a form, basically no filtering. And the Chart seems to be able to handle the selection of a Legend.
If I add a hard Criteria, "ZS" in the Criteria section, the chart will still display the Legend OK.
However, if I change the criteria to a variable pulled off of a form, then the chart just shows blank.
example: [Forms]![Frm_FilterSetup_rev01]![txtBx_SalesDivision1]
I'll have a little more time today to play with this. Then with tomorrow being the first of the month, I may get tied up with other things for a few days.
I'll try to put together a database that emulates the problem that I can send you.
But I may not be able to get to it until early next week.
Thanks again for your time and patience.
