how do i loop through all the records in a database? I have tried just adding 1 to the autonumber combobox but it only supports text so it doesnt work. i have tried converting it to a string then converting it back but this also doesnt work. is there a command to cycle through a the records?

if anyone can offer some help i would be greatful. thanks