I am having some problems. I have a table with certain file name criteria to match in file name but it isnt working correctly. I am using InSTR but I feel like I should be using a different command. Any help would be greatly appreciated.
If InStr(1, rs![FName], rs1![BuClient]) And InStr(1, rs![FName], rs1![Identifier]) And InStr(1, rs![FName], rs1![Identifier 2]) Then
objFSO.MoveFile strsourcefolder, strDest & "-" & initials & "-" & rs![FName]
Code:
objFSO.MoveFile strsourcefolder, strDest & "-" & initials & "-" & rs![FName]
Code: