Combo box, Command Button, Hyperlink

[Ed in Aus]

Hi,

Not sure how to approach this but here is what I intend on doing:

I have a combo box that looks up via SQL

SELECT tblIndustries.ID, tblIndustries.Industry, tblIndustries.Hyperlink
FROM tblIndustries;

what I need is when you hit the a command button "Command87_Click" it goes to the hyperlink in the SQL statement.

 

[HiTechCoach]

Hi,

Not sure how to approach this but here is what I intend on doing:

I have a combo box that looks up via SQL

SELECT tblIndustries.ID, tblIndustries.Industry, tblIndustries.Hyperlink
FROM tblIndustries;

what I need is when you hit the a command button "Command87_Click" it goes to the hyperlink in the SQL statement.

try:

Application.FollowHyperlink Me.ComboBoxName.Column(2)

 

[Ed in Aus]

Thank you that worked perfectly

 

[HiTechCoach]

You're welcome.

Glad we could assist.