I have a db table that has a series of fields like this....

myfile.butn1
myfile.cap1
myfile.butn2
myfile.cap2
myfile.butn3
myfile.cap3
...

I have a command that needs to be run on each field in the table...

thisform.butn1.caption="\<1"+chr(13)+trim(myfile.cap1)
thisform.butn2.caption="\<2"+chr(13)+trim(myfile.cap2)
thisform.butn3.caption="\<3"+chr(13)+trim(myfile.cap3)

can this be looped somehow using a FOR or something similar to step through the
all the fields replacing the #'s above with a variable or something? This is a simple
example but a couple other methods are going to have multiple commands for each
field in the file (all commands are the same for each field except for the field names
switching

Thanks