Step through the program in your debugger and stop it immediately after the assignment to selectStatement. Display
selectStatement
in the watch window or Immediate window.
You want it to look exactly like this ...
UPDATE Paytest SET Imagename = 'C:\Ezc\Files\' + [bates] + '.TIF'
Which I expected ProgramFOXs statement suggestion would have achieved ...
selectStatement = "UPDATE Paytest SET Imagename = '" + newPath + "' + [bates] + '.TIF'"
NB this is assuming newPath = @"C:\Ezc\Files\"