Looping through table fields
Posted on 2011-09-24
I have a table such as
... plus 70 more fields
I want to create a loop that displays a msgbox showing the contents of about 20 of these 70 fields
for loopy in friend1,friend4, friend7 , friend10
msgbox loopy.value 'This should show the value of the field e.g. Jon Smith
I simply want to display 20 values of the 70 of the current record.
Obviously my loop syntax is all wrong.
Can anybody give me a working piece of code for the above loop.