[AccessD] Put fieldname into a variable

I would like to put a table's fieldname into a variable, and run code
like the following:

(I've omitted most of the code because of space)

Dim fld as Field

Dim i as Integer

 

Do until rst.EOF = True

     i = i + 1

     fld = rst![Field" & i & "]

     ... do processing

Loop

 

Any ideas how this can be done?

 

Mark Boyd

Sr. Systems Analyst

McBee Associates, Inc.