Link record with a visio file

[Stuart Green]

I might be asking too much here, but here goes.

I have staff who use Access to record details about clients' accounting systems. They also often draw flowcharts of the system using Microsft visio. I would like to have a "CREATE DRAWING" button on the input form that would allow them to open a new Microsoft visio file from access automatically named after the clients unique reference and let them draw as required. The file name and path needs to be saved with the access record so that if a drawing already exists they can review or amend it by clicking on an "REVIEW DRAWING" button


Any ideas please?
(PS, never written a module in my life so be gentle!)