help with a loop

[buggy2]

i have a large table in my database called 'mytable'. it has 26 fields. i would like to loop through and print via a message box to the screen all the values of the 3rd field in my table. Call the fields a1,b2,c3,........

In this case i need all the values from fields "c3".

 

[garyd1234]

Try this

Assuming this is a DAO database, goto tools references and make sure the Microsoft 3.6 Object Library is checked. Then put this code behind a button on the form.

dim db as dao.database
dim rs as dao.recordset
set db=currentdb()
set rs=db.openrecordset("select c3 from Mytable")
while not rs.eof
msgbox rs![c3]
rs.movenext
wend
db.close