Selecting a web page based on a cascading combo

S

scubadiver

Hello,

I need some code which will allow me to open a specific web page based on
the choice of two combo boxes.

The URL is generic apart from the two choices.

Thanks
 
N

NthDegree via AccessMonster.com

scubadiver said:
Hello,

I need some code which will allow me to open a specific web page based on
the choice of two combo boxes.

The URL is generic apart from the two choices.

Thanks
Click to expand...

For the After Update trigger for the second combo box (the one that would
provide that last section of the URL) simply concatenate the beginning text
and the two combo boxes to create the complete URL. In the sample code the
combo boxes are named cboPartTwo and cboPartThree:

Private Sub cboPartThree_AfterUpdate()

Dim strCompleteURL as String
Const strDefaultURL as String = "http://www.nowhere.com"

strCompleteURL = strDefaultURL & cboPartTwo & cboPartThree

End Sub
 
S

scubadiver

Hello

thanks for that but I think I have sorted it out.

I do have a similar query though. I want to open a word document and the set
up is similar. The documents are in one of two folders ("location"), will
have a document prefix and (obviously) a name. I have included the ".doc"
extension.

I have:

An initial document path
Combo1 Name: Location
Combo2 Name: Prefix
Combo3 Name: Document

The cascade for these combos works ok.

I am not sure what to do now!

thanks.
 
Top