html within combo box?

[shy216]

is it possible to make a selection from a combo box and link a distinct html depending on the selection?

 

[Aivars]

Hi!

The hyperlink support only controls of type acLabel, acImage, acCommandButton. But it's possible to solve it using label control.

Example.
Create a combobox named "Combo0", and label named "Label0"
Set the folloving Combobox data:
RowSourceType: Value List
RowSource: "

http://www.microsoft.com";"http://www.tek-tips.com"

Copy and paste the folloving into form module vindow.

Private Sub Combo0_AfterUpdate()
With Me.Label0
.Visible = False
.HyperlinkAddress = Me.Combo0
.Hyperlink.Follow True
End With
End Sub

Good luck!
Aivars

 

[shy216]

would that work /w multiples tho?
like each selection from the combo box linking to different website?

 

[PHV]

You may try this in the AfterUpdate event procedure of the combo:
Application.FollowHyperlink Me![combo name].Value

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[shy216]

does that mean i need to set the values of the cbo box as a html? where would i put html values?