Thanks in advance!
I've created a command button to find a .doc file. This file has a path that includes the record's phone number in the file name. I'm using this code to try and pull the file, but debugger says it can't find the file.
Private Sub Command155_Click()
Dim oApp As Object
Set oApp = CreateObject("Word.Application")
oApp.Visible = True
AppActivate oApp
oApp.Documents.Open FileName:=FilLoc & "C:\FirstUSA\Prospects\ & forms![FirstUSA].[Phone1] & .doc", readonly:=readonly
Set oApp = Nothing
End Sub
I need this to pull the current record I'm viewing. In other words, insert the record's phone into the path that I'm currently viewing.
Thanks!