ACC: How to Create a Graph Bound to Two Combo Boxes (1.x/2.0)ID: Q109323
|
Moderate: Requires basic macro, coding, and interoperability skills.
This article describes how to create a graph that is bound to two combo
boxes. You can control the data that is displayed in the graph with your
selections in the combo boxes.
The following example demonstrates how to set up a graph that is bound to
two combo boxes:
Query: QueryTest
-----------------------------------------------------
Field Name: Order Amount
Table Name: Orders
Total: Sum
Field Name: Product Name
Table Name: Products
Total: Group By
Field Name: Category ID
Table Name: Products
Total: Group By
Field Name: Year: CStr(NulltoZero(Year([Order Date])))
Table Name:
Total: Group By
Object: Combo box
-----------------------------
ControlName: SelectCat
RowSourceType: Table/Query
RowSource: Categories
Object: Combo box
---------------------------------
ControlName: SelectYear
RowSourceType: Value List
RowSource: 1989;1990;1991;1992
Object: Object Frame
-----------------------------------------
ControlName: Embedded0
LinkChildFields: Category Id;Year
LinkMasterFields: SelectCat;SelectYear
Keywords : kbtool IntpGrph
Version : 1.0 1.1 2.0
Platform : WINDOWS
Issue type : kbhowto
Last Reviewed: March 30, 1999