Accessing Graph properties in a report

[AaronWestcott via AccessMonster.com]

Hello all,

I am using Access 2003 and am trying to dynamically change the contents of a
graph in a report based on user input. I have discovered that accessing the
properteis of a graph in a report is more complicated than expected. However,
I am still having trouble getting the access.

Understand I am new to this so my code could be complete garbage.

The unbound object name is Chart1 and the report is called TESTCHART (I am
trying to get this to work first before doing it for real)

I have looked thorugh other threads but given how new I am to VBA programming
I am not sure I have a complete grasp of how the Object model is structured
or how to read it and declare what needs to be declared.

Any help would be greatly appreciated.

Best Regards,

Aaron

 

[Duane Hookom]

I generally create a similar chart in Excel. Then I turn on the Macro
Recorder and make changes that I want to capture in code. After turning off
the recorder, the basic code is located in the workbook's module. With a
little effort, you can copy and paste it into your report on Format of the
section containing the chart.

You will need to change some of the object references. Sorry, can't help you
much more. I usually muck my way around using this method.