I have a form with 2 ComboBoxes which add together to form
both parts of a file URL.

eg. CB1 CB2
My Documents Spreadsheet1
Spreadsheet2


When the desired parts are highlighted a CommandButton is
pressed leading to another form. This second form has a
textbox and I would like it to state the file's address.

eg My documents\Spreadsheet1

Another CommandButton is pressed which then activates the
desired file.

Is this possible? Can anyone help me?

Thanks in Advance

James