Using MS Access report with Visio

[Syed Rizvi]

I would like to use Visio organizational chart with Microsoft Access Report.
When I click on one of the boxes it will open up Access query based report
showing some details about the position. Could that be possible?

I was checking Shape > Behaviour > Run macro feature but it limits to the
pre-defined macro only. Is there a way to add a new macro into list.

Any suggestions or help would be appreciated, thanks
Syed

 

[David Parker]

You can write your own macros in Visio VBA.
These macros can be in the drawing document, but are usually best to
centralize in a stencil document.
They can be run with CALLTHIS or RUNADDONWARGS function.