Hello,

I have a database with customer information. I would like to add a
button
that will dynamically open a visio diagram of their network based on
the
customer name.

For example if ABCCo has a visio diagram when you open the form with
the
product details you will be able to click on a button that will open
thier
Visio diagram.

I have tried to do this with the CreateObject (visio.application), but
I
would rather have the visio document embedded in a form so that all
viewing
is done in Access. The Diagram does not have to be editable, just
viewable.

I have also tried dragging and dropping the visio diagram (this does
not
allow the dynamic population I would like) and the size is
enormous...Is
there a way to make the visio diagram strech and shrink to whatever
size the
form is?

What I would do is name the visio diagram [Customer].vsd so the same
form
would be opening, but Access would dynamically populate the form with
the
correct Visio diagram.

Also, not all customers provide a visio diagram . Is it possible to
make the
button visible only when a matching diagram is present.

Any help would be appreciated.
thanks,
Jessie