Creating a Graph in a report...

Hello,

I'm creating a graph on my report. To do this I'm creating
a Microsoft 2000 Graph Object.

The problem I'm having is I get the same graph for every
record in my query. I know I'm getting different records
each page as I print the values at the top of the page But
the graph never changes!

Using the properties of the Graph object I tried using
the "Link Child Fields" and "Link Master Fields" to
facilitate the changing of records but I get a message -
"Cant build a link between unbound forms"

Any ideas?

Thanks in advance

Andy

I assume you get the message when you click on the builder ('...') control on the link child/master property.
Just type in the linking fields, don't bother trying to use the builder. Might also help to have a hidden textbox in the detail containing the linking field.

Additionally type this code in the Print event of the group that holds the chart:

Private Sub WHATEVER_GROUP_THE_CHART_IS_IN_Print(Cancel As Integer, PrintCount As Integer)
On Error Resume Next
Dim objGraph As Object
Set objGraph = Me.NAME_OF_GRAPH_OBJECT.Object
objGraph.Refresh
DoEvents
Set objGraph = Nothing
End Sub

Basil

----- wrote: -----

Hello,

I'm creating a graph on my report. To do this I'm creating
a Microsoft 2000 Graph Object.

The problem I'm having is I get the same graph for every
record in my query. I know I'm getting different records
each page as I print the values at the top of the page But
the graph never changes!

Using the properties of the Graph object I tried using
the "Link Child Fields" and "Link Master Fields" to
facilitate the changing of records but I get a message -
"Cant build a link between unbound forms"

Any ideas?

Thanks in advance

Andy

THANK YOU BASIL!
-----Original Message-----
I assume you get the message when you click on the
builder ('...') control on the link child/master property.
Just type in the linking fields, don't bother trying to
use the builder. Might also help to have a hidden textbox
in the detail containing the linking field.

Additionally type this code in the Print event of the
group that holds the chart:

Private Sub WHATEVER_GROUP_THE_CHART_IS_IN_Print(Cancel
As Integer, PrintCount As Integer)
On Error Resume Next
Dim objGraph As Object
Set objGraph = Me.NAME_OF_GRAPH_OBJECT.Object
objGraph.Refresh
DoEvents
Set objGraph = Nothing
End Sub

Basil

----- wrote: ----
-

Hello,

I'm creating a graph on my report. To do this I'm
creating
a Microsoft 2000 Graph Object.

The problem I'm having is I get the same graph for
every
record in my query. I know I'm getting different
records
each page as I print the values at the top of the
page But
the graph never changes!

Using the properties of the Graph object I tried
using
the "Link Child Fields" and "Link Master Fields" to
facilitate the changing of records but I get a
message -
"Cant build a link between unbound forms"

Any ideas?

Thanks in advance

Andy

.