Been looking through the script commands and tried it slightly differently :
tell application "Finder"
set myWindow to make Finder window to folder "Macintosh HD:Users:Chris:Dropbox"
open folder "Macintosh HD:Users:Chris:Dropbox"
activate myWindow
end tell
Yours is much simpler and neater though
Just one point. After the trigger command the Alfred window still has the workflow appended underneath, similar to the screen shot in my original post. Hitting 'enter' brings up the DropBox window. Is this the standard behaviour? It looks as though it is but I want to be sure in case I'm missing something for future use.
Been using your workflow and so far it always does bring the window to the front once I've hit 'enter'.
Interesting stuff. Thanks for the help.