Combo box-Hyperlink

[cktcPeterson]

Is there a way to have a combo box and when click on the option it opens a hyperlink?

I have a table with the list of forms and then I have a webpage to get the form

Table fields
File Name
File link

 

[theDBguy]

Have tried the Application.FollowHyperlink method?

 

[cktcPeterson]

No. Could you guide me a little more on that?

Right now have the combo box with 2 fields and when I select the form, the hyperlink shows. I then click on it.

I want to stream line that process.

 

[moke123]

Dont use hyperlink datatype. Use a string with just the link.

In your combo use 3 columns. Your primary key, the name for your link, and your link (as a string)

In the after update event put

Application.FollowHyperlink Me.yourComboName.Column(2)

 

[cktcPeterson]

This is what I put and it does not work

Private Sub cboInvoices_AfterUpdate()
Application.FollowHyperlink Me.cboInvoices.Column(2)
End Sub

My combo box has 2 fields
File name and the hyerlink field (not as a hyperlink datatype)

I get an error
Invalid use of Null

 

[theDBguy]

This is what I put and it does not work

Private Sub cboInvoices_AfterUpdate()
Application.FollowHyperlink Me.cboInvoices.Column(2)
End Sub

My combo box has 2 fields
File name and the hyerlink field (not as a hyperlink datatype)

I get an error
Invalid use of Null

If your combo only has two columns, then Column(2) is referring to a third column.

Can you show us the SQL statement for your combo's row source? Thanks.

 

[cktcPeterson]

Perfect. I got it to work. I changed it to (!)

 

[theDBguy]

Perfect. I got it to work. I changed it to (!)

Glad to hear you got it sorted out. Good luck with your project.