Double Clicking Record In List Box to Open Hyperlink Take 2

[springa]

Good morning all,

I have still been unable to find a way to do this:

I have a list box "Item List"on a form "Order Form"with these columns/fields : Item ID, Item Name, Item Category, Item Description, Item Photo and WH Stock taken from a query "Stock In Store/WH".

The Item Photo is a hyperlink to a file for that specific item's photo on a networked PC. On double clicking a specific record, I would like the hyperlink to open.

Thanks very much

 

[maxmangion]

Hi,

Search this forum for Application.FollowHyperlink and you should solve your problem.

 

[springa]

Hi maxmangion,

Thanks for your reply.
Can't seem to find anything when I search for that? Do you by any chance know where this thread/post would be? I am getting quite desperate to get this working, starting to drive me up the wall. Thanks very much.

 

[maxmangion]

On the OnDoubleClick event put Application.FollowHyperlink "Your Image path goes here"