Print fields

[gmit]

Hi
I'm trying to print fields to a text file, I have managed this no problem but I can only seem to print one field and I want more!
I have the following code that uses the print statement

Print #ArchiveNo, rsTblStudent.Fields("First Name")
I would like to be able to add extra fields so I amended the code to be

Print #ArchiveNo, rsTblStudent.Fields("First Name","Last Name","Address")
but I get an error message when running this code, isn't the syntax for this

recordset.fields(field1,field2,field3,etc)
if so any ideas were I'm going wrong?

 

[Pat Hartman]

Print #ArchiveNo, rsTblStudent.Fields("First Name"), rsTblStudent.Fields("Last Name"), rsTblStudent.Fields("Address")

 

[gmit]

Thank you for your help