Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004
    Posts
    78

    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?

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    496
    Provided Answers: 24
    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

  3. #3
    Join Date
    Jan 2009
    Location
    Kerala, India
    Posts
    183
    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.
    www.MsAccessTips.com (Learn MS-Access Tips & Tricks)
    Learn Advanced MS-Access Programming with sample VBA Code.

    All responses are based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •