NEED MS CHART HELP IN ACCESS

[hnwfsu]

i need to know how to build a chart dynamically from search criteria in a form. i can't seem to set the row source in code...how is this done for a chart in an access report???

thank you thank you thank!!!!

 

[LizardKingSchwing]

I have an access db which uses the MS Chart and what I did was build up tables for the source to the chart , these tables are built in code and are setup as following

Y Axis
|
v
X Axis Columns -> Legend |2|4|6|8|10|12|14|16|18|20|22|24|
Users
Errors


The Chart uses the Legend values Users and Errors as Bars on chart , and the numbers represent time...

There may be an easier way to source the Chart, but this worked for me

LK--<