Private Sub OpenFolder_Click()
Dim FolderName As String
FolderName = Me![PR#] & ", " & Me![Serial] & ", " & Me![Name]
Dim ProjectPath
ProjectPath = "\\Server\Share\" & FolderName
Shell "c:\WINDOWS\explorer.exe """ & ProjectPath & "", vbNormalFocus
End Sub
I can have it search on any of the fields in the record, but the older
folders, thousands of them, did not necessarily follow the exact
naming scheme. However, the PR# is ALWAYS correct, this is why I want
to do something like I did above, which works, but allow it to search
for only PR# regardless of what comes before, or what follows it. I
am still new to this whole coding behind the forms thing, but think I
can get there with a little nudge. Thanks for all off your help.