Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Graph Rowsource (Access2k)

    Can the rowsource for a graph be set in the OnOpen event? I've done this with regular reports but couldn't see where to do it for a graph.
    I'm trying to cut down on the ammount of graphs I need to create by just changing the rowsource and using a static graph.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Graph Rowsource (Access2k)

    Reports are different from forms in this respect. You can't set the row source of a chart on a report in the On Open event of the report, ar at any later moment while the report is open in print preview. The only way to do it is to open the report in design view, change the row source of the chart, then switch to print preview. Details in ACC2000: How to Set the RowSource Property of a Report Graph Dynamically.

    Note: if you have multiple users, you must give each user a private frontend database, for you can't change the design of database objects when multiple users have the database open.

    If possible, see if you can use a parameter query as row source. This allows you to display different data sets without changing the design of database objects.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Graph Rowsource (Access2k)

    Thanks Hans, I'll experiment with that

Posting Permissions

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