Problems with Charts

  • Thread starter Thread starter graham
  • Start date Start date
G

graham

Trying to create a simple report with data and a graph. I
created the report using one table and three fields; DB,
DATE, and Charges with DB as a grouped header/footer, Date
and Charges as the detail.

In the DB footer I inserted a graph, selected the same
query the report was based on, choose to link master/child
fields on DB, and ran.

The report runs fine, and the graph at the bottom of the
detail looks great, except that It's not properly linking
the DB field. ie the report detail data is for DB "ABC"
but the graph is for "DEF"?????

When I go into the properties, and try to relink
master/child fields (which are properly listed as DB, I
get an error stating that

"Can not build a link between unbound forms"

any help????
 
Sorry, one more question, what if you have more than one
graph in that section?

How would you write the code to refresh both graphs?

Thanks again
 
First of all, I believe this is a bug. If a wizard programmed around it,
then they might as well have fixed the bug.

Dim oGraph As Object
Me.Graph1.Requery 'supply your object name vs "Graph1"
Set oGraph = Me!Graph1
oGraph.Refresh
oGraph.Object.Application.Update
Me.Graph2.Requery 'supply your object name vs "Graph2"
Set oGraph = Me!Graph2
oGraph.Refresh
oGraph.Object.Application.Update

Set oGraph = Nothing
 
Back
Top