Print fields

gmit

Registered User.
Local time
Today, 14:12
Joined
Jan 27, 2004
Messages
23
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?
 

Users who are viewing this thread

Back
Top Bottom