Currently I am working with ACCESS Basic 2.0. I have to write some code that selects records from a table and inputs the record into a text file with a required format. I have used to Print #, functionality to print to the file. Everything works, except that I cannot figure out a way to name the file to match a field in the record. I.E. Each record has and application #, each record will be printed to its own text file and should be named or saved as whatever the application # is (the application # is a field in the record), move to next record, create new text file…etc.



I am not really sure if it would be possible to do this in ACCESS Basic.

Any ideas?

Thanks in Advance