Help and Support
 

powered byLive Search

ACC: How to Create a Graph Bound to Two Combo Boxes (95/97)

Retired KB ArticleThis article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
View products that this article applies to.
Article ID:155757
Last Review:January 19, 2007
Revision:3.4
This article was previously published under Q155757
Moderate: Requires basic macro, coding, and interoperability skills.

SUMMARY

This article describes how to create a graph that is bound to two combo boxes. You control the data that is displayed in the graph by making selections from the combo boxes.

Back to the top

MORE INFORMATION

1.Open the sample database Northwind.mdb.
2.Create a new query in Design view, and add the following tables: 
       Orders
       Order Details
       Products
       Categories
3.On the View menu, click Totals.
4.Add the following fields to the query grid: 
       Field: Freight
          Table: Orders
          Total: Sum
       Field: ProductName
          Table: Products
          Total: Group By
       Field: CategoryName
          Table: Categories
          Total: Group By
       Field: Year: CStr(Nz(Year([OrderDate])))
          Total: Group By
5.Save the query as qryGraph and close it.
6.Using the Chart Wizard, create a new form based on the qryGraph query.
7.In the "Which fields contain the data you want for the chart?" dialog box, add SumofFreight, ProductName, and CategoryName to the Fields for Chart column, and then click Next.
8.In the "What type of chart would you like?" dialog box, click the Column Chart, and then click Next.
9.In the "How do you want to lay out the data in your chart?" dialog box, drag CategoryName to the Axis (bottom of graph) and drag ProductName to the Series (right side of graph), and then click Next.
10.In the "What title would you like for your chart?" dialog box, type Freight Dollars by Category, and then click Finish. The form will open in Form view.
11.On the View menu, click Form Design.
12.On the View menu, click Form Header/Footer.
13.Add two combo box controls to the Form Header section with the following properties: 
       Combo Box:
          Name: SelectCat
          RowSourceType: Table/Query
          RowSource: Categories
          ColumnCount: 2
          ColumnWidth: 0";1"
          BoundColumn: 2

       Combo Box:
          Name: SelectYear
          RowSourceType: Value List
          RowSource: 1993;1994;1995;1996
14.Click the graph, and modify the following properties of the unbound object frame: 
       Unbound Object Frame:
          Name: FreightGraph
          SizeMode: Zoom
          LinkChildFields: CategoryName;Year
          LinkMasterFields: SelectCat;SelectYear
          Width: 6.5"
          Height: 3.25"
15.Switch the form to Form view. Click different categories and years in each of the two combo boxes on the form and note that the contents of the graph change.

Back to the top

REFERENCES

For more information about graph control properties, search the Help Index for "graph," and then "Chart Control Properties," or ask the Microsoft Access 97 Office Assistant.

For more information about combo box properties, search the Help Index for "combo boxes, properties" and then "Combo Box Control Properties" or ask the Microsoft Access 97 Office Assistant.

Back to the top

APPLIES TO
•Microsoft Access 95 Standard Edition
•Microsoft Access 97 Standard Edition

Back to the top

Keywords: 
kbhowto kbusage KB155757

Back to the top

Article Translations

 

Other Support Options

  • Need More Help?
    Contact a Support professional by E-mail, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.