This will eventually be a Append Query and why I want to store the file loaction and file name in this field in the query.

What is the syntax or what coding do I need to do on the form or in the query to get this to work?

Thanks in Advance

Hi Ronald
Is the name of your form Forms!VettrakWaitlistF ? Why does the code have "Waitlist"

John

OutputFileFld is a VBA variable, and VBA variables can't be used inside a query in such a manner.  You either to need to use string concatenation to to combine the SQL statement with the VBA variable, or create a custom VBA function that returns the value you want, then put the custom VBA function inside the query.  For your situation, the latter is probably simpler (although the former is the better way, and is how this kind of thing is usually done).  See the picture below as an example: