var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Update chart based on record selected
I have a crosstab that shows total sale by customer.
Cust Jan Feb Mar Apr
100 22 0 0 0
200 0 555 66 0
300 3 0 6 8
400 0 0 0 0
Now i need a chart that should be based on a crosstab .
The chart should only display one customer.
Every time I select a customer, the chart should be refreshed.
Anyone can help me?
Where do I start?
In a form ,show the data sheet as a sub form.
User selects a record, then clicks a button to open the Chart.
Open the chart using the 1 record based on the name of the cust field:
Docmd.openreport "rMyChart", acPreview, "[cust]=" & me.subFrm.Cust
The example given on the following link explains how to display a PIE Chart on a form based on the values on the current record:
PIE Chart and Live Data on Form.
You may create a Bar/Line Chart, if you don't prefer a PIE chart.
(Learn MS-Access Tips & Tricks)
Learn Advanced MS-Access Programming with sample VBA Code.
All responses are based on Access 2003/2007