Hi Chris,

Couple of things I notice:

1. Your destination is missing the filename.
2. The line fso.CopyFile Source, Destination, [overwrite]
        [overwrite] should be a Boolean value (True/False)
        fso.CopyFile Source, Destination, True

What is the value of [overwrite]?  Enclosed in square brackets, it is treated as a field, and that may be why you get the "can't find field" error.  Try:

fso.CopyFile Source, Destination, True

or

fso.CopyFile Source, Destination, False

"Overwrite" is an optional argument for CopyFile, and it should be a boolean value.  It tells Access whether to overwrite an existing file or not.  It is optional, so it can be omitted.  If omitted, its default value is True.

CopyFile has quite a few caveats, so read all about them here:
ttps://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/copyfile-method

Hi Kevin And Kevin... the Boolean was the issue.. thanks for pointing that out. turns out unless you want to change the file name the destination does not need a filename specified.