You can't set the value of a file field.
You can set the default value of the file upload field in the file upload server behavior... that is where you set it to the existing recordset value.
Your update query should be set to the Upload File value "Server File Name". It will contain the name of the uploaded file if one was uploaded and will use the default value (set to the recordset field) when no file is uploaded.


