Access VBA - Help would be much appreciated

I have a form in access that includes a WebBrowser ActiveX Control. The reason i have this is to show the contents of a folder on our server within the access database. i.e. the link is "\\Bermuda\public\Research\" (bermuda is the name of our server)

How do i now change the link so that it includes a field that is part of the record that is currently being displayed. Each record relates to a folder name on the server and i want to be able to view that specific folder on my form. NB all folders are subfolders of \\Bermuda\public\Research\

My current code is as follows:

Private Sub WebBrowser5_Enter()

WebBrowser5.Navigate "\\Bermuda\public\Research\"

End Sub

I am think along the lines of the following:

Private Sub WebBrowser5_Enter()

Dim folder As AccessObject

Set folder FolderLocation

WebBrowser5.Navigate "\\Bermuda\public\Research\" & folder

End Sub

I am really just guessing the above code but hopefully it should show what i want to do. (NB FolderLocation is the field name in my database)

Thank you

Freddie

If you check the documentation you'll no longer need to guess.

try using folder.name