I have a database containing hyperlinks to DVD-ROMs that store images. I now have several of these DVD-ROMs, each identifiable by a unique reference number.
A field in the database holds the unique reference number for the DVD that contains the image for each record. What I would like to do, instead of having to remember look at the DVD reference field each time, is to have a message box pop open asking for the DVD by the reference number, but only if it has changed since the last time the hyperlink to an image was clicked. e.g. If the selected image linked to is on DVD 1 and DVD 1 is in the drive, do nothing, otherwise open a mesage box requesting (for example) DVD 3 be placed in the drive. Thank you. Perry
