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

ID: Q155757


The information in this article applies to:
  • Microsoft Access versions 7.0, 97


SUMMARY

Moderate: Requires basic macro, coding, and interoperability skills.

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.


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.



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.

Keywords : kbusage FmsCmbo
Version : 7.0 97
Platform : WINDOWS
Issue type : kbhowto


Last Reviewed: April 28, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.