Can I return the fieldname rather than the value from a recordset

[jacq]

I need to get the field names rather than the values from a table. I have tried creating a recordset to get the field name using .name or .field but I keep getting errors. Is there a way to get the names using a recordset or should I be trying another approach?

 

[hennep]

try this:

dim rs as recordset
dim f as field
set rs=currentdb.openrecordset("table1&quot
for each f in rs.fields
debug.print f.name
next f