RE:Scrolling records using Ado data control...

[jeffro]

I would like to scroll through a databases records from a vb form. I'm trying to use the ado data control but it will not allow me to scroll through the records. It's like the ado control is disabled, but in the properties box it is in fact enabled.

Please help if you can, I'm ready to pull my hair out! HA!

[DrewDog_21]

how about posting the code where you set the control's properties?

please see if u have set the connection property of the adodc properly. to see the record i think u have to bind them to the appropriate controls after u have connected. when u r connecting try testing the connection to see that the connection is ok. there could any reason for u to not be able to scroll thru.

[jeffro]

Hello

I have got the ado data control to scroll through the records now, but when I scroll to the last record to add a new record, it will not let me scroll back to see the other records. You know if I change my mind and not want to enter a new record. Is there an sql statement I would have to write?