Form Data output to text file

[applevacross]

I've created a form within our company database which will track hardware/software requests. I'd like to create a macro, or add code to output the data entered into a notepad file. Nothing extraordinary. I'd like for it to be like this:

Ticket: XXXXX
Employee: xxxxx
Reason for Request: xxxxx
Quantity:xxxxx
Part Number:xxxxx
Price:xxxxx
Shipping:xxxxx
Total:xxxxx

Those are the headings of the fields and x's denote entered data. I'd like to keep the headers and have the entered data as well. Is it possible?

Thanks to all for your help

 

[FoFa]

You could create a sub that writes the information right to a file (using the old Basic OPEN and WRITE LINE) verbs.
You could use the newer FileSystemObject to do basically the same thing.
You could create a table and put the data in say one text column, then use transfertext to create the file.
Just off the top of me head.