Export to a user-specified location: Access 308 is a great tutorial for automating the export of data to a txt or alternate file, however, it only provides the ability to export to a statically specified file. Is there a way to have Access export to a location that is specified on a field on another form. I have been playing around with this, both in vba and macros and can't get it to work. For example, if the form that also contains the button for executing the macro or vba code also had an unbound field that the user could specify the location and file name to export to, I would like to reference that field as the file location. I have tired just about every syntax I can think of and can't get it to work. This would allow the user to save the file in any location or file name. Also, by doing this, I could set it up so that the user could use the file browser to specify the location. Thanks for your advice and I love your tutorials.