I created a recordset, and am able to scroll through the recordset by using the movenext property, and then taking the values (Ex: rs(1).value) and then diplaying that equal to the text of the textbox (Ex: text1.text = rs(1).value)

however, i do have about 30 text boxes to do this to.

it works, but seems a little slower than it should be to just move to the next record.

another idea i tried was to set the datsource and datafield name of the text box. this way i can just display the first record in the recordset, but can't see the other records even when i use the movenext property.

so..i guess my question is...
1) Whats the best way to do this that will be the quickest
2) in my 2nd way, is there something i need to do, to beable to scroll through the other records,
3) any other ideas that would help me accomplish this?