Hyperlink from Combo Box

  • Thread starter Thread starter Matthew Ellis
  • Start date Start date
M

Matthew Ellis

I would like to use the selection in a combo box to follow a hyperlink. I have the combo box displaying the description and the actual address (http://ipaddresshere). So there are two columns in the combo box, although I could do with just the description if it makes things easier. Any advice on the best way to do this? What would be even cooler would be to have the hyperlink open within Access, but I would settle for opening in the default browser on the system. Thanks for the help. Let me know if you need more info. I am feeling a bit scatterbrained today.
 
Hi Matthew,

Something like

Application.FollowHyperLink Me.cboXXX.Column(1)

should do it, after adjusting the name of the combo box and the column
number. Probably call it from the combo's AfterUpdate event or from the
Click event of a button on the form.

That will open the default browser. To open on the Access form itself,
put a Web Browser control on the form and write code to manipulate it.



I would like to use the selection in a combo box to follow a hyperlink.
Click to expand...
I have the combo box displaying the description and the actual address
(http://ipaddresshere). So there are two columns in the combo box,
although I could do with just the description if it makes things easier.
Any advice on the best way to do this? What would be even cooler would
be to have the hyperlink open within Access, but I would settle for
opening in the default browser on the system. Thanks for the help. Let
me know if you need more info. I am feeling a bit scatterbrained today.
 
Back
Top