graph in detail section of a report

[SunWuKung]

I am trying to create a report where there is one graph for every record in the detail section of the report. I can place the graph in the detail section but I don't know how to generate a different graph for every value.
I tried to change the rowsource property of the graph in the OnFormat event but it gives an error message.

Any suggestion how this can be done?
Many thanks.
SWK

 

[SunWuKung]

Thanks Pat,
that was the trick (as your signiture says).

I found the master/child field thing before but it gave me inconsistent results so I quit trying. Now that I force requery it works perfectly.

Thanks again.
SWK